AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N9365HAugusta Aviation Inc · Agusta, GAN9365JTrujillo Mark A · Corvallis, ORN9365KSchlecht Erich T · Pasadena, CAN9365LHartzog Christopher G · Greenwood, SCN9365PHolly Gerald C Jr · Soldotna, AKN9366DLongboard Energy LLC · Broken Arrow, OKN9366HPowell Jonathan L · Violet Hill, ARN9366JDnr Aircraft LLC · Mesa, AZN9366MHouse Oscar · Wakefield, RIN9366WRegistered aircraftN93673Flight Trainer LLC · Wilmington, DEN9367DMccreery Aviation Co Inc · Mcallen, TXN9367HDeralex Airways LLC · Miami, FLN9367LHummel Mark I · Lakewood, WAN9367MGriffith Jason R · Guyton, GAN93689Board Of Trustees DBA · Murphysboro, ILN9368DMiller 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, DEN9369FSauer David A · Palmetto Bay, FLFirst renewal noticeN9369JIcarus And Son LLC · Wilmington, DEN9369LNichols David M · Medford, ORN9369RTwark Eric James · Fort Collins, CON9369SLindauer Curt C III · Belleville, ILN9369TTarno Suzzan G · Avondale, AZN9369WJulius Jonathon · Casey, ILN936AZN936az LLC · Miami, FLN936BWTriple J Aviation LLC · Mcconnelsville, OHN936CPCivil Air Patrol · Maxwell Afb, ALN936CSTextron Aviation Inc · Wichita, KSN936LTAerosim Flight Academy · Sanford, FLN936MBBergstrom Aircraft Inc · Pasco, WAN936PRD & D Air Inc · Dover, DEN936RGrandinetti Robert L · Fayetteville, NYN936RJBullion Richard G · Louisville, CON936RVTaylor Thomas D · Harper, TXN936SCSprang Robert · Smithville, OHN936SPHard Way LLC · Dover, DEN936TELevine Gary H · Davie, FLN93706Drake Charles R · Claremore, OKN93707Vertol Systems Co Inc · Destin, FLN9370LLawrence Guy · Bakersfield, CAN9370RFlight Trainer LLC · Wilmington, DEN9370SSheehan Robert K · Edmond, OKN9371JBosker John A · South Bend, INN9371KEverglades Aviation Academy LLC · Weston, FLN9371NTial Aviation Inc · Wilmington, DE
Back to AD 81-18-04 R2