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.
N82196Flying W Ranch Jv · Cooperstown, NDN8219GSchaum Jerome B · Machipongo, VAN8219WA18 Missions LLC · Clinton, MON8219YDurden Julian F Jr · Twin City, GAN821ATSeminole Aircraft LLC · Wilmington, DEN821BABarr Air Patrol LLC · Mesquite, TXN821BERas Aviation LLC · Elyria, OHN821BFDehn Timothy E · Braham, MNN821BPPerdue Joseph D · Marshall, OKN821CETedesco Michael Anthony · Monroe, CTN821CPCivil Air Patrol · Maxwell Afb, ALN821DBFlying Old Glory LLC · Kalispell, MTN821DHMilsap Charles M · Owensboro, KYN821EREmbry Riddle Aeronautical University · Daytona Beach, FLN821ESSchmitz Mark J · Ames, IAN821FJ8th Dimension Enterprises LLC · Aurora, ORN821GMHoosier Aviation LLC · Terre Haute, INN821KCIreland Robert D Jr · Gulf Breeze, FLN821LLindrooth Steven A · Perkasie, PAN821PASkywest Leasing Inc · St George, UTN821PCJones Clark L · Cave Creek, AZN821PTHermes Ana Paula F · West End, NCFirst renewal noticeN821RFAlaska Island Air Inc · Togiak, AKN821RPVan Cleave Raymond D · Kalispell, MTN821SJc/Rc Ventures LLC · Key West, FLN821SDGlobal Adventures N821sd LLC · Hollywood, FLN821SHAero Leasing Inc · Brookings, ORN821STNorthwestern Michigan College · Traverse City, MIN821WTVest Michael S · South Beach, ORN821WWDouble Whiskey Flyers LLC · Highlands Ranch, CON82209Pearl Darwyn L · Bend, ORN8220PParsell Scott · Katy, TXN82213Anderson Stephen A · Yuba City, CAN8221GIshoy Glen · Indiana, PAN8221NFedchenko Vitaliy · Cumming, GAN8221YBill Kennedy Aviation LLC · Stuart, FLN82221Hahn Dave · Brooklyn Park, MNN82225Dow Clifford G II · Falmouth, MEN82226Plane & Pilot News · Ravenna, OHN8222DPaphos Airways LLC · Farmingdale, NYN8222FJefferson City Aviation Inc · Jefferson City, MON8222HBartek Matthew S · Wylie, TXN8222JShvetsov Vitaly S · La Canada Flintrid, CAN8222WMitzel Aaron · China Spring, TXN8222YMorale Line Aviation LLC · Albuquerque, NMN82236Ingle Nicholas A · Cora, WYN822397 Dolors LLC · Urbana, OHN8223CCurless Timothy A · Demotte, INN8223NEvans Jay M · Arrington, TNN8223TTrident Aircraft Leasing LLC · Easton, MD
Back to AD 81-18-04 R2