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.
N9174VFrink Jeff · Chandler, AZN9174WKwan Andrew W · Lynnwood, WAN91751Aviators Cooperative LLC · Colorado Springs, CON9175GRepelatron Skyway LLC · Wilmington, DEN9175JSommer Eric M · London, OHN9175WHamilton Lee A · Franklin, INN9176Elias Bernard J · Hampton, GAN9176DSmaha Daniel B · Glide, ORN9176ETyrrells Trails LLC · Fairbanks, AKN9176HSky Walker Flight School LLC · Adrian, MIN9176JPayson Aero Club LLC · Payson, AZN9176NWjr Aviation Inc · Caledonia, MIN9177DCheyann Jordan · Coupeville, WAN9177EBell Joseph · Lakewood, CAN9177HLind Enterprises LLC · Manistee, MIN9177SNabeth Jeremy S · Austin, TXN9177WBartels Gary A · Daykin, NEN9178CKelly Randall Shawn · Rocklin, CAN9178LClarke Paul W · Cape Girardeau, MON9178QMartinez Manuel G · Downers Grove, ILN9178SSwoboda Kristin · Boise, IDN9178VWingman Aviation Partners LLC · Wentzville, MON9178WBoyd Dean W · Merrill, WIN9178YPurdy Louis John · Pahrump, NVN91793Oexmann James Bennett · Lexington, KYN9179CLiewer Timothy M · Anselmo, NEN9179EFrisco Flyers LLC · Macedonia, ILN9179HMeteiver Lawrence J · Elkhart, INN9179SCharles Clarens · Brooklyn, NYN9179VVinter Mooney LLC · Philadelphia, PAN9179WVangura David · Ponte Vedra Beach, FLN917AXGast Matthew Adam · Weston, WIN917CMKaraszewski Michael J · Pensacola, FLN917DKEncore Jet Management LLC · San Antonio, TXN917FAAlpha Aircraft International LLC · Lake Worth, FLN917GDAir Charter Inc DBA · Culebra, PRN917GKAmdel Holding LLC · Houston, TXN917KDRegistered aircraftN917KFHillsboro Aero Academy LLC · Hillsboro, ORN917MAKs Flying Club Inc · Manhattan, KSN917MBRegistration Pending · Ravenel, SCRegistration pendingN917PFBrown Charles James · Littlefield, TXN917RCRegistration Pending · Longmont, CORegistration pendingN917TCDebarros David · Ashland, VAN917VFRickerson Brock C · Garnett, KSN917VKNorthern Lights Ventures LLC · Moose Pass, AKN917WETaylor William H II · Albuquerque, NMN917WSRv Time LLC · Cape Coral, FLN917WTStamsta David T · Ennis, MTN917XKirkegaard Lewis J · Grand Junction, CO
Back to AD 81-18-04 R2