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.
N55000Gross Flying Service Inc · Larned, KSN55001Eastern Stearman Inc Trustee · Leesburg, VAN55007Av8 Inc · Westborough, MAN5500CDuncan Robert L · Greenville, MSN5500EAllen Aviation LLC · Houston, TXN5500GCummings Terence J · Morgan Hill, CAN5500LWinchell Lawrence R · Salem, NJN5500MDecathlon Training Inc · Saint Louis, MON5500UJones Donald T · Barrigada, GUN5500WKansas State University · Salina, KSN5500YMccormick Herbert L · Port Orange, FLN5500ZPfc Aviation Repair Inc · Wallingford, CTN55010Royal Aviation Academy LLC · Sarasota, FLN55018Stiver Roger M · Nashville, ARN55019Berry Kirby T · Poolville, TXN5501AProfly LLC · Wichita Falls, TXN5501FWade Joshua Michael · Saline, MIN5501NRoddy Warren D · Skokie, ILN5501WTailwinds Aviation LLC · Kokomo, INN5501YBas Part Sales LLC · Greeley, CON55021Robertson Alan L · Hastings, NEN55023Charron William H · Burwell, NEN55028First Alarm Aviation LLC · Fosters, ALN55029Chandler William John · North Palm Beach, FLN5502AAero Enterprises LLC · Orange, VAN5502CWebb Brad · Ekron, KYN5502HSky View LLC · De Smet, SDN5502MRegistered aircraftN5502PBeans David W · Sharpsburg, MDN5502QAcademy Computer Services Inc · Stoneham, MAN5502U90 Degree Crosswind LLC · Arcadia, FLN5502WWest Kentucky Wings And Toons LLC · Benton, KYN55030Reiner John G · Wakefield, MIN55031Monaghan Management Corp · Greenwood Village, CON55032Jacks Dean E · Madison, INN55033Mcneill James R · Wichita, KSN55034Osceola Aerosport LLC · Osceola, WIN5503AKey Dallas T · Hoover, ALN5503CMccreary William J · Glendale, AZN5503FN5503f Aircraft Holdings LLC · Orangeburg, SCN5503HCp Aviation Inc · Santa Paula, CAN5503JFalterman Patrick J · Cleveland, TXN5503LAnderson Firearms LLC · Montgomery, TXN5503PCore Tech Services And Supply LLC · Odessa, FLN5503QPrecious Metal Aviation LLC · Menomonee Falls, WIN5503UFuller Christopher Jason · Destin, FLN5503VPurstell Kevin D · Burnt Hills, NYN5503YBundt Benjamin L · Montebello, CAN55041Napier Clarence M · Mount Juliet, TNN55042Rohrbaugh Mark A · Lenexa, KS
Back to AD 81-18-04 R2