AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N9360CPure Joy Aviation One LLC · Schaumburg, ILN9360RWaggener Chris E · Clyde, NCN9360SWitt Dan W · Lancaster, SCN9360VHarvey John S · Garland, TXN9361FRmw Services LLC · Mckee, KYN9361MR&D Mooney Inc · Osprey, FLN9361SAviation Services LLC · Oshkosh, WIN9361VDanson Corp · Henderson, NVN9361WRadecki Louis J · Helenville, WIN9362CThanheiser Heige · Lincoln, NEN9362JSandy Bottom LLC · Nantucket, MAN9362NPool Busters LLC · Lake Bluff, ILN9362VYoon Philip K O · El Cajon, CAN9362WJennings Brandon M · Asheboro, NCN9363MBaas John M · Rapid City, SDN9363NWeiman William R · Howell, MIN9363SDtb Holdings LLC · Cheyenne, WYN9363VEye Squared Holdings Inc · Houston, TXN9363WMoffitt Albert · Wolfforth, TXN9364DSimmons John E · Anchorage, AKN9364JBerthiaume Richard R · Millbury, MAN9364MShelton Douglas S · Kingsville, MDN9364PTougas William E · Timberlake, NCN93657Jewett Lucas D · Helena, MTN9365HAugusta Aviation Inc · Agusta, GAN9365JTrujillo Mark A · Corvallis, ORN9365KSchlecht Erich T · Pasadena, CAN9365PHolly Gerald C Jr · Soldotna, AKN9366DLongboard Energy LLC · Broken Arrow, OKN9366HPowell Jonathan L · Violet Hill, ARN9366JDnr Aircraft LLC · Mesa, AZN9366MHouse Oscar · Wakefield, RIN9366WRegistered aircraftN9367DMccreery Aviation Co Inc · Mcallen, TXN9367HDeralex Airways LLC · Miami, FLN9367MGriffith Jason R · Guyton, GAN9368DMiller Jonathan L · Anchorage, AKN9368JPierce Cale G · Fort Walton Beach, FLN9368NSocal Resorts LLC · Big Bear Lake, CAN9368VMontrose Paul F · Greenbrier, ARN9368WBalderrama Arturo · Mcminnville, ORN9369DHackett Joel W · Georgetown, DEN9369JIcarus And Son LLC · Wilmington, DEN9369PLoadstone Aviation LLC · Billings, MTN9369RTwark Eric James · Fort Collins, CON9369SLindauer Curt C III · Belleville, ILN9369WJulius Jonathon · Casey, ILN936AZN936az LLC · Miami, FLN936BWTriple J Aviation LLC · Mcconnelsville, OHN936LTAerosim Flight Academy · Sanford, FL
Back to AD 87-10-06 R1