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.
N5405MToozer Air LLC · Ormond Beach, FLN5405PJohnson Sidney · Madison, MNN54067St Pete Aviation Services LLC · Saint Petersburg, FLN5406LLone Roger D · Prosperity, SCN5406PDerksen Ronald E · Xenia, ILN5406WScott Jeffrey E · Connersville, INN5406YKillam Rodney A · Carlinville, ILN5406ZRains Kenneth W Jr · Lebanon, TNFirst renewal noticeN54073Center O Flying Club · Tumwater, WAN54079Christiansen Aviation LLC · Wilmington, DEN5407FFly Quest Aviation LLC · La Verne, CAN5407HPye Jennifer · Roanoke, TXN5407LStech Stuart · Fredericksburg, TXN5407WThird Step 6 LLC · Gilbert, AZN5408ECutbirth Henry R · Monahans, TXN5408HSchmidt Kelly D · Lake Elmo, MNN5408PZero Eight Papa LLC · Dublin, OHN5408RRegistration Pending · Brookland, ARRegistration pendingN5408USanders Aviation Inc · Jasper, ALN5408WTriple M&W LLC · Bloomfield, IAN5408YHargreaves William A · Lovettsville, VAN54093Kamenev Alexey · Hinsdale, ILN54094Mustang Sally Aviation LLC · Camden, SCN5409FBlackwolfden Aviation LLC · Belgrade, MTN5409JKelley Aircraft LLC · Weyers Cave, VAN5409LBarnhardt Robin J · Eleva, WIN5409MJackson David B · Mansfield, TXN5409PReinaudi Gael · New York, NYN5409RMclane Tucker · Newton, MAN540ACChristians Ricky P · Appleton, WIN540ADHorst Kendall N · Smoketown, PAN540ARAmerican Rentals 6 LLC · Dousman, WIN540AWMyers Thomas R · Palo Alto, CAN540BBMey Gary P · New Bern, NCN540BCBeranek James · Cottage Grove, ORN540BDBrajer Animo LLC · Ostrander, OHN540BELemons Brooks D · Visalia, CAN540BJGreene Charles A · Pilot Point, TXN540BKPaggen Troy D · Parker, CON540BNHyannis Air Service Inc D/B/A · Hyannis, MAN540BRRegistered aircraftN540BSSeay Edward A · Signal Mountain, TNN540BTChristensen Hans P · Enterprise, UTN540CFCertified Aviation LLC · Morristown, NJN540CWCentral Washington University · Ellensburg, WAN540CZOrr David A C · Lake Forest, CAN540DASmith Dustin · Layton, UTN540DGHargreaves William A · Lovettsville, VAN540DML-Bird LLC · Hood River, ORN540DRToribio LLC · San Antonio, TX
Back to AD 81-18-04 R2