AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N2156RWinfrey Walter A Trustee · Auburn, CAN2157GAviation Bravo Corporation LLC · Palm Coast, FLFirst renewal noticeN2157SSchlenker Wesley E · Dallas, TXN2157ZHamel Ryan Alan · Klamath Falls, ORN21581Skyline Aviation Inc · Racine, WIFirst renewal noticeN21587B & D Fuel Injection Service Inc · Rhoadesville, VAN2158CSlocum James E · Poplar Grove, ILN2158JMccormick Eugene C DBA · Tyler, ALN21593Peyt Rentals LLC · Cobb, GAN21597Gsw Flyers LLC · Pittstown, NJN21598Kcsi Aerial Patrol Inc · Bakersfield, CAN2159GKirchoff Kevin B · Millington, TNN215DJGreat Plains Aviation LLC · Scott City, KSN215HGGazzaz Hussein · Lakeway, TXN215JInnovative Aerodynamic Technologies · Yorktown, VAN215RGGonzalez Rogiero A · San Antonio, TXN21608Mmt87 LLC · North Miami, FLN2160CStephenson Stephanie V · Colby, KSN2160JSnider Scott DBA · Turner, MTN2160RPaper Plane LLC · Hotchkiss, CON2160SGalkin Edwin N Dmd · Edison, NJN2161CHendrix Todd M · Bakersfield, CAN2161PRegistered aircraftN2161RKlemme Aviation LLC · Davenport, IAN21624Ellis Archer A · Shady Shores, TXFirst renewal noticeN21626Low Level Aero LLC · Myakka City, FLN2162GOdiorne Bruce Lamar II · Durango, CON2162LN2162l LLC · Tyler, TXN2162ZBaker Benjamin K · Anchorage, AKN2163JPortland Police Bureau · Portland, ORN2163RRupp Michael David · Lunenburg, MAN2163SOlde Towne Transport LLC · Beaufort, NCN2163ZHennis Jesse J · Nampa, IDN21653Skyhawk Holdings LLC · Waco, TXN2165CHaltom Alan W · Centennial, CON2165GStanley Aviation LLC · Stanley, NDN2165RSproket Industries Inc · Fulton, CAN2165ZRegistered aircraftN2166CMaples Jeffery · Belle, MON2166RKrom Raymond L · Brighton, MIN2166ZCherry William Wallace Jr · Muldoon, TXN2167GBtp Inc · Missoula, MTN2167PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2167RTake It Easy LLC · Durango, CON2168CHowerton Pammela S · Bartlesville, OKN2168RNd Aero Solutions LLC · Bismarck, NDN2169MVan Bortel Aircraft Inc · Arlington, TXN216BANordic Flyers II LLC · Plymouth, MNN216DCDornink Steven R · Birchwood, WIN216JKKelly James C Jr · Bonaire, GA
Back to AD 84-10-01 R1