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.
N9344HBarnstormers Flying Club Inc · Pulaski, TNN9344JBiamonte Thomas John · Ventura, CAN9344LCivil Air Patrol Inc · Maxwell Afb, ALN9344SScram Branden L · Fairbanks, AKN9344VOchoa Hougan Michael H · Chino Hills, CAN9344WEmery Nelson J · Emporia, KSN93454Marsh John E · Washington, DCN9345AAdamson Donald R · Lonoke, ARN9345JGrady John O · West Chester, OHN9345LHaynie Aviation LLC · Alexander City, ALN9345MMichael Matthew C · Ames, IAN9345SEvans Brian W · Laceys Spring, ALN9345VBroussard Troy A · Dickinson, TXN93468Bestway Transport LLC · Raymond, NEN9346DHolloway James H · Merritt Island, FLN9346JAhern Walter B · Durango, CON9346SWilson Ronald Q · Claremore, OKN9346WRegistration Pending · Crosby, TXRegistration pendingN9347HWings Like Eagles LLC · Wilmington, DEN9347TLewis University · Romeoville, ILN93488Rawareo LLC · Warsaw, MON9348HDeshazer Bill G · Gladewater, TXN9348MSauter Ross S · Cleveland, OKN9349DFoote Jason D · Osakis, MNN9349JPfingsten Leon R · Sheldon, NDN9349LKearney Isabelle · Oklahoma City, OKN9349RMccelvey James L · Dilley, TXN9349YTravel Air Inc · Bayville, NJN934AZN934az LLC · Miami, FLN934BRdp Air LLC · Viroqua, WIN934CPCivil Air Patrol · Maxwell Afb, ALN934DJMann Thomas A · Ford, WAN934EREmbry Riddle Aeronautical University · Daytona Beach, FLN934GRGrossman Robert W · Andover, MAN934LTAerosim Flight Academy · Sanford, FLN934MT8th Dimension Enterprises LLC · Englewood, CON934NDUniversity Of North Dakota · Grand Forks, NDN934RVDe Silva David I · Carolina, PRN934TESpiwak Andrew · Canyon Lake, TXN934TRAris Leasing Inc · Sunnyvale, CAN9350DWade Richard L II · Valdez, AKN9350FSale Reported · Perry, GASale reported, pending cancellationN9350JElliott Peter J · Riverside, CAN9350KPanjab Aviation · Las Vegas, NVN9350MPella Technology Services Inc · Pella, IAN9350VSprunk Stephen · Anderson, OHN9350WBlock Scott M · Chandler, AZN9351DJennings David M · Huffman, TXN9351FCarr Sam H · Spring, TXN9351HBrown Daniel Thomas · Layton, UT
Back to AD 81-18-04 R2