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.
N62486486 Aviation LLC · Worthington, OHN62488Leaf Air LLC · Queensbury, NYN6248BDel Mar College District · Corpus Christi, TXN6248CFort Leavenworth Flying Club · Fort Leavenworth, KSN6248DEscobar Frank · Tampa, FLN6248MRoss Michael M Trustee · Anchorage, AKN6248RHewitt Chad R · Vernonia, ORN62491Registration Pending · Strawn, TXRegistration pendingN6249PKeller Richard A · Stacy, MNN6249VN6249v LLC · Park Ridge, ILN6249WWall Scott R · Franksville, WIN624ATiffany Connor D · Naknek, AKN624ACAnunson Andrew M · Pound, VAN624APThomas Lucas G · Beebe, ARN624AQHigh Flight Academy LLC · Allison Park, PAN624BBravo Aircraft LLC · Alpharetta, GAN624BBPetey LLC · Lake Arrowhead, CAN624BLBurril Casey J · Elba, ALN624BTJespersen Barry W · Olympia, WAN624CECertified Equipment Inspections LLC · Washington, PAN624CJJones Steven Clark · Flagler Beach, FLN624CWSkypeck John · Nevada City, CAN624DGRv4 Adventures Inc · Wilmington, DEN624EPEpic Aviation Inc · New Smyrna Beach, FLN624FTFlorida Institute Of Technology · Melbourne, FLN624HNeed For Speed Inc · Dover, DEN624JTStandhart Gary · Wickenburg, AZN624LLLevin Larry R · Lincoln, RIN624MCStauffer Mark A · Appleton, WIN624MMLee Douglas A · Truckee, CAN624MSMcclure George E Jr · Nipomo, CAN624NDZaki Amir S · Orangevale, CAN624PAGeneral Aviation LLC · Henderson, NVN624RCJeffrey Guy · Centerburg, OHN624SStoro Eddy · Netarts, ORN624SEPrysi Mary H · Dundee, OHN624SXDeeds Andy · Larkspur, CON624TBBoard Of Trustees Of Western Michigan University · Battle Creek, MIN624TCArnaoutis Antonios D · Ormond Beach, FLN624TFDominy Kenneth W · Ave Maria, FLFirst renewal noticeN62502Hill Andrew T · Smithville, TXN62503Back Forty Flying Club Inc · Roanoke, INN62506Stevenson George Otis · Wheatland, WYN6250CShields Ray Winfrey III · Marietta, GAN6250UAsb Jones Aviation · Uniontown, OHN6250WCummings Property Restoration LLC · Bullard, TXN62511Dezee Matthew J · Corinth, KYN6251JGamache Bernard J · Yakima, WAN6251LDavis William Ray · Cypress, TXN6251PPearce Donnie D · Mena, AR
Back to AD 81-18-04 R2