AD 2002-01-10
Registered aircraft · 816
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-10')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-10') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N64CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN64KAXin Han Aviation LLC · Helena, MTN655DFBlue Earth Flying Service LLC · Blue Earth, MNN6563KBeech Transportation Inc · Eden Prairie, MNN65MSSummey Aviation LLC · Asheville, NCN65TADodson International Parts Inc · Rantoul, KSN65UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN65VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN662JSHughes Leasing Co · Miami, FLN665JKSprinklermatic Florida LLC · Davie, FLN6681SN6681s LLC · Helena, MTN6692DWisodak Air LLC · Eau Claire, WIN66ADRed Light Skydiving LLC · Jackson, MIN66GSMile Hi Skydivers Inc · Longmont, CON66KAMullins Michael · Seaford, DEN66WDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN671LLCentral Virginia Aviation Inc · North Dinwiddie, VAN6723YKair Air LLC · Marietta, GAN6754HAviation Communication And Surveillance Systems · Phoenix, AZN6763KAla Ark LLC · Germantown, TNN677JHobbs Aircraft LLC · Waco, TXN67BDynamic Avlease Inc · Bridgewater, VAN67CQBeech Baron LLC · Wilmington, NCN67KDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN67VSouthall Properties LLC · Vicksburg, MSN681CAJet Air Inc · Galesburg, ILN681EVQb Corp · Salmon, IDN681SDJefferson County Sheriffs Office · Beaumont, TXN682KALott Dalton Leon · Duncanville, TXN683MG1976 King LLC · Scottsdale, AZN687MMBuckeye Fluids LLC · Wilmington, DEN68CDSkydive Myrtle Beach Inc · Southport, NCN690GLathem Russell Glen · Dalhart, TXN690KABank Of Utah Trustee · Salt Lake City, UTN692WGuardian Flight LLC · Lewisville, TXN699CCC & C Market Research Inc · Fort Smith, ARN6KZDodson International Parts Inc · Rantoul, KSN7000BBeechcraft Heritage Museum Inc · Tullahoma, TNN7007GDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeN70088School Of Missionary Aviation Technology · Ionia, MIN700DHGramer Air II LLC · Bloomfield Hills, MIN700WWAces Full Inc · Deadwood, SDN7010LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeN7014LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeN7018FDynamic Aviation Group Inc · Bridgewater, VAN701NCNorth Country Aviation Inc · Gaylord, MIN701XPFlight Partners 2 LLC · Lincoln, NEN70292Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeN70356Dynamic Aviation Group Inc · Bridgewater, VAFirst renewal noticeN7036LDynamic Aviation Group Inc · Bridgewater, VAFirst renewal notice
Back to AD 2002-01-10