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.
N7145RBozinoff Kenneth K · Palmer, AKN7145WZhelez Alex · Deer Park, WAN7145ZSkyberg Jeffrey A · Circle, MTN7146GHalladay Roy · Erie, CON7146PRichardson Eeseh A G · Loganville, GAN7146QPressley Aviation LLC · New London, NCN7146RGrider Gary W Jr · New Boston, TXN7146WWhitford Nathan · Brunswick, OHN7147LFletchair Inc · Comfort, TXN7147UCurtin Matthew T · Cedar Hills, UTN7147YLee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYN7148Prescott Scot · Alburgh, VTN7148AHillsboro Aero Academy LLC · Hillsboro, ORN7148KNormark Ronald L · Weirsdale, FLN7148QRosevelt Jane · Lake Oswego, ORN7148UN192ag LLC · Mckinney, TXN7148WNorden Robert · Tappan, NYN7149DGuerin Donna N · Woodville, ALN7149KMichel Daniel T · Sterling, AKN7149LBell Larry B · Albuquerque, NMN7149RPayne William R · Old Forge, NYN7149UBas Part Sales LLC · Greeley, CON7149VLeghorn Aero Services LLC · Waynesboro, VAN714AKHartt Andrew F · Millinocket, MEN714ASSantos Andres A · Barranquitas, PRN714BGWatts Perry J · Monte Vista, CON714DBradtke Jonathon · Springfield, MON714DYChamberlain Phillip Lee · Lake Charles, LAN714EDKirkland Stephen M · Winston Salem, NCN714EYStevens Matthew S · Penn Yan, NYN714FLFather John 77 Flying Club Inc · Flushing, MIN714HRegistered aircraftN714HJNorth Georgia Grading Inc · Jasper, GAN714HPTic Aerospace Inc · Miami, FLN714HWNational Training 1 LLC · Wilmington, DEN714LAReese Cassidi A · Grand Forks, NDN714LULiberty University Inc · Lynchburg, VAN714MDPittsburgh Pilot Training LLC · Bethel Park, PAN714NDUniversity Of North Dakota · Grand Forks, NDN714SStoeppler Heidi Lynae · Sioux Falls, SDN714SCJuliet Charlie Aviation LLC · Oregon City, ORN714SWMackin Robert M · Castro Valley, CAN714TAPaterson Fraser · Torrance, CAN714TCJt Air LLC · Luling, LAN714TESale Reported · Molino, FLSale reportedN714TJTop 5 Media LLC · Santa Maria, CAN714TMVetter Brent E · Helena, MTN714TRStocks Kristian · Billings, MTN714TUDamschroder Rex A · Fremont, OHN714UCStroud James DBA · Union, SC
Back to AD 81-18-04 R2