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.
N7333XFrederick Aero Development Inc · Murrieta, CAN7333YMayotte Stephen A · North Chelmsford, MAN7333ZSoaring Society Of Dayton Inc · Waynesville, OHN73345N73345 Aviation LLC · Sheridan, WYN7334FWings Flight Enterprises Inc · Danville, KYN7334GEllis Gregory D · Winnsboro, TXN7334YJg Air LLC · Cape Coral, FLN73354Sky Partners LLC · Sylacauga, ALN73357Aerospace Trust Management LLC Trustee · Wilmington, DEN7335GJordan Jeffrey B · Woodland, WAN7335KPeterman Karen S · Holiday, FLN7335WWhitworth Kenneth W · Hanford, CARegistration expired, pending cancellationN73361Snyder Steven S · Norfolk, VAN73362Spanaflight LLC · Puyallup, WAN73365Toliver David R · Lenexa, KSN73367Martinez Jose Antonio · Orlando, FLN7336BWild Robert · Woodbury, NJN7336DJohnson Dale M · Seminole, TXN7336JKey West Aviation LLC · Key West, FLN7336WDemers Matthew H · Plano, TXN7336ZBruegger Traylin T · Lance Creek, WYN73370Bay Flying Services LLC · Pinconning, MIN73371Elliott Aaron · Scott City, KSN7337GReiss Alan T · Puyallup, WAN7337LKiehl Flying Service LLC · Winnett, MTN7337QCopper Ridge Express LLC · Iowa Falls, IAN7337WReynolds Jessica C · Maricopa, AZN73381Wings Over Texas Holdings LLC · Denton, TXN73383Ludington Rental LLC · Ludington, MIN73387Bartley Darrell Jr · Somerset, KYN73388Wings Over Texas Holdings LLC · Denton, TXN7338FKyle Aviation Services LLC · North Charleston, SCN7338PPope Kent M · Hayden, IDN7338WEvans Russell Slade · Austin, TXN73391Holdgate Irvin F · Englewood, FLN73395Quick Caleb B · North Newton, KSN73398Wintons Wings LLC · Bardstown, KYN73399Stone Mary A Trustee · Weeki Wachee, FLN7339FLambright Kevin L · Shipshewana, INN7339KMendez Jessica A · Jacksonville, FLN7339MBroadwell Group Inc · Acworth, GAN733ABKalman Engineering Inc · Pekin, ILN733ADMarshe Aviation LLC · Upland, CAN733AEMackey Aviation LLC · Talking Rock, GAN733AGRick Aviation Inc · Newport News, VAN733AHAltus Aircraft LLC · Taylor, TXN733AJ578 Airplane Leasing Inc · Kissimmee, FLN733AKParker Helicopters Inc · Watsonville, CAN733AMGlendale Community College · Glendale, CAN733ANAtlas Epigrin Aviation LLC · Austin, TX
Back to AD 81-18-04 R2