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.
N70000Carson Mark L Trustee · Northfield, MNN70004Gbl Aviation LLC · Laurel, MSN7000RJilek Peter Andrew · River Falls, WIN7000WIndy Air Sales LLC · Anderson, INN7000XWalsh Peter F · Walpole, MAN7000YSlowpoke Air LLC · Palm Harbor, FLN7001DOwens Eldon J · Arimo, IDN7001KJersey Devil Dusters LLC · Southampton, NJN7001PPavlusik Tibor · Fort Mill, SCN7001WBrinc LLC · Lancaster, PAN7002KHeinze Gregory L · Little Rock, ARN7002PMonterey Bay Aviation Inc · Watsonville, CAN7002ZKistler Michael J · Wasilla, AKN70032Alpha Wings Inc · Willoughby, OHN7003BByrd Kyle E · Unionville, MON7003PAviation Career Enrichment Inc · Atlanta, GAN70046Zane Newton F · Rllng Hls Est, CAN7004FSouthern Vector Aerospace LLC · Huntsville, ALN7004GMcgreen John R · Albany, NYN7004REasley Leroy · Novelty, MOFirst renewal noticeN7004WLettsome Nesco · Beltsville, MDN7005Paragon Airplane Leasing Co · Fort Myers, FLN70052Hastings Heidi · Wasilla, AKN7005GHamilton Peter D · Bear, DEN7005QCentral Arkansas Flying Club Inc · Bryant, ARN7006QToney Edward L · Hampton, GAN7007Command Aero LLC · Newark, DEN70075Kennel Isaac John · Salt Lake City, UTN7007JKeltner Kody M · Meadville, PAN7007KJackson Gary Lynn · Simms, TXN7007PAden Charles L · Hudson, CON7007TAnderson Karen Lynn · Wasilla, AKN7007WBiros Timothy D · Nya, MNN7007XConcho Aviation LLC · Sterling City, TXN7008AMitchell Shawn J · Red Bluff, CAN7008BMayes Russell F · Farmersville, ILN7008NRobinson Helicopter Company Inc · Torrance, CAN7008RPerchall Theodore G II · Fort Myers, FLN7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLN70095Eastern Kentucky University · Richmond, KYN7009DRegistration Pending · Waupaca, WIRegistration pending, pending cancellationN7009KRay Tyler D · Wasilla, AKN7009QJoiner Legacy Enterprises LLC · Joliet, MTN7009RJackson Donald W · Carthage, MSN7009WFarrell Thurston Construction LLC · Las Cruces, NMN700AC4sons LLC · Mayfield, KYN700AGMash Kity J LLC · Grand Rapids, MIN700ASGunderson David A · Box Elder, SDN700AWTailwheel LLC · Logan, UTN700BVN700bv LLC · Zeeland, MI
Back to AD 81-18-04 R2