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.
N6341PShumberger Ryan M · Carlisle, PAN6341QSanderson Shawn · Chelan, WAN6341RBethany Holdings LLC · Jamestown, NCN6341SPradels Karis J · Murrieta, CAN6341TGoose Leasing LLC · Ashburn, VAN6341WMangham Aviation LLC · Mullin, TXN6342BFargo Jet Center LLC · Fargo, NDN6342DCourtney Walter William · Cameron Park, CAN6342LHillsboro Aero Academy LLC · Hillsboro, ORN6342RNagle George · Phillipsburg, NJN6342WAg Air Squadron Two LLC · Saint Joseph, ILN6342XRainier Flight Service LLC · Renton, WAN6343DAir One Aircraft LLC · Portage Des Sioux, MON6343ECatskill Mountain Air LLC · Milford, NYN6343NHenderson Scott · Cocoa Beach, FLN6343PMcgowan John B · Sunnyvale, CAN6343QWindsock Aviation LLC · Edmond, OKN6344CPayne Ernest Charles · Dana Point, CAN6344LCheney Dustin S · Phillipsburg, KSN6344NPlane Fun Inc Tr Trustee · Snellville, GAN6344PStanford Scott M · Spring Branch, TXN6344QSoseman Christian James · Maricopa, AZN6344RGalaxy Electronics LLC · Hallandale Beach, FLN63450Skywarrior Flight Training Inc · Pensacola, FLN63456Ace Of Spades Aviation LLC · Las Vegas, NVN6345CKrajewski Jerry J · Elgin, ILN6345DRumble Aviation LLC · Thomasville, GAN6345JHaywood Ken P · Acworth, GAN6345NColeman Darryl W · Fayetteville, GAN6345QPerry Edward Glen Trustee · Ozark, ARN6345VBas Part Sales LLC · Greeley, CON63461Georgia Golf Cars Inc · Douglas, GAN6346D6d Leasing LLC · Englewood, CON6346ERudd Richard L · Cornelius, NCN6346JSons Thomas · Norwood, MNN6346MElston Josh · Sterling, AKN6346NYoung Marlon V · Santa Rosa, CAN6346RBuresh Noah A · Blair, WIN6346TNemec Jeffery W · Bowling Green, KYN6346VPierobon Luciano I · Port Orange, FLN6346WCottrill William M Jr · Joplin, MOFirst renewal noticeN63470University Of Central Missouri · Warrensburg, MON6347DAnthelion LLC · Flemington, NJN6347JGrove City Aviation LLC · Mercer, PAN6347LMcdonald Brion J · Palo Alto, CAN6347MPavco Inc · Gig Harbor, WAN6347PGear Down Hangar LLC · Phoenix, AZN6347TWang Peter Z · Germantown, MDN63482Hess Garrett J · Fullerton, CAN63483Eagle Sky Patrol Inc · Deadwood, SD
Back to AD 81-18-04 R2