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.
N7287ZQuality Aviation Inc · Marana, AZN72883Donovan Robert J · Bothell, WAN72884Hawkeye Aviation LLC · Miami, FLN7288FJ&S Aeronautics LLC · Mcgregor, TXN7288KAgha Thanoon J · Anchorage, AKN7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeN7288WIndependence Youth Flying Club Inc · Independence, ORN7288YN7288y LLC · Manassas, VAN7289JValdez Jose C · Troy, MIN7289KIberlin Christian J · Gillette, WYN7289LMott Calvin L · Rolla, MON7289WHarris Clark R · Tribune, KSN7289ZWerth John F · Hays, KSN728AMeridian Aircraft LLC · Wilmington, DEN728BLRamey Dale J · Atascadero, CAN728CMSchweitzer Gregory M · Tabernacle, NJN728DBStyer David B · Pendleton, ORN728DFExplore Helicopters LLC · Lexington, ALN728DMForkel Stephen P · Bend, ORN728EBeaver Companies LLC · Shelby, NCN728EREmbry-Riddle Aeronautical University Inc · Prescott, AZN728FGRidgeline Assets LLC · Wilmington, DEN728FLFalcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedN728GLMartin James D · Graford, TXN728HRVelasco Higareda Ignacio L · Valencia, CAN728HVBig Bang Air LLC · Wichita, KSN728JWMagnusson Dwayne · Anchorage, AKN728KGCapsed LLC · Mojave, CAN728KKWeddle Stephen J · Phillips, WIN728LUTextron Aviation Inc · Wichita, KSN728NDUniversity Of North Dakota · Grand Forks, NDN728PHornsby Mark · Jackson, LAN728RTBurnside Jack · Rockwall, TXN728TBAtd Pilot Training LLC · Kansas City, MON728TKStefanidis Dimitri T · Lake Oswego, ORN728TSSky King LLC · Baltimore, MDN728WVeldman Richard D · Laporte, INN728WCUnmanned Systems Inc · Henderson, NVN728WFReigh Galen R · Williamsburg, PAN728ZIrizarry Eduardo F · Columbia, SCN7290JPiper Nicolas A M · Atherton, CAN7290KAnderson Brent J · Whitewater, MTN7290PFarmland Investments Inc · Mound City, MON7290VChristen Aviation LLC · Pawnee City, NEN7291DLehman John Thomas · Corbett, ORN7291FTusing Richard C · Newell, SDN7291GKuntz Jeffrey A · Covington, OHN7291JCenterline Equipment Corp · Waukegan, ILN7291PHenris Air LLC · Onsted, MIN7291WKiser Eugene A · Sheboygan, WI
Back to AD 81-18-04 R2