Skip to content

Registered aircraft · 6,916

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

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:97-01-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:97-01-01-R1') ORDER BY n_number

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:97-01-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:97-01-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:97-01-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:97-01-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.

N1582XInnovative Aviation LLC · Indiana, PAS/N 28R-7535340 N15832Mickschl Bradley J · Avon, INBuilt 1972 · S/N 28R-7335093 N15839Phoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350100 N15862Butler Michael W · Sacramento, CABuilt 1972 · S/N 28R-7335098 N15894Dunlap Dalton · Port Neches, TXBuilt 1972 · S/N 28R-7335102 N158CCRegistration Pending · Visalia, CARegistration pendingBuilt 1977 · S/N 28R-7737081 N15909Downes Pamela M · Chino Hills, CABuilt 1972 · S/N 28R-7335104 N1590XLanders Stephen F · Riverview, FLBuilt 1975 · S/N 28R-7535344 N15919Tikhomirov Anton · Ashland, MABuilt 1973 · S/N 28R-7335106 N15925Everglades Aviation Academy LLC · Weston, FLBuilt 1973 · S/N 34-7350109 N15931Smitty 172 LLC · Rockford, MIS/N 28R-7335108 N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345 N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004 N15BREllis David E Jr · Midlothian, TXBuilt 1978 · S/N 32R-7880004 N15CBAaviation LLC · Telford, PABuilt 1976 · S/N 28R-7635291 N15MZCaillarec Philippe · Le RheuNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28R-7803274 N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388 N160LMMino Leonard G · Pueblo West, COBuilt 1958 · S/N 24-79 N160MJFoley Robert A · Columbia, NJS/N 30-1410 N161PRegistered aircraftBuilt 1958 · S/N 24-533 N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952 N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121 N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125 N16293Quale Jeffrey L · Craig, COBuilt 1973 · S/N 28R-7335123 N162BWSimply Living LLC · Fort Myers, FLBuilt 1975 · S/N 34-7570147 N162PMFrench Loren · Gypsum, COBuilt 1963 · S/N 30-72 N16311Toxen Robert M · Fort Lauderdale, FLBuilt 1973 · S/N 28R-7335124 N16321Chamberlain Frederick L · Tavernier, FLBuilt 1973 · S/N 28R-7335126 N16329Greensite Phillip M · Walton, KYBuilt 1973 · S/N 28R-7335129 N16361Fly 361 LLC · Doswell, VABuilt 1973 · S/N 28R-7335134 N16362Flightline Air Service LLC · Pineville, LABuilt 1973 · S/N 28R-7335135 N16368Tougas William E · Timberlake, NCBuilt 1973 · S/N 28R-7335136 N16395Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1973 · S/N 28R-7335141 N16422Ardupilot Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335145 N16429Hilbish David B · Chicago, ILBuilt 1973 · S/N 28R-7335112 N16437Novawings Aviation LLC · Porter, TXS/N 28R-7335146 N16459Chase Charles D · Baskin, LABuilt 1973 · S/N 28R-7335150 N1652HDemelva Aviation LLC · Alexandria, VAS/N 32R-7780168 N16530Beldon Concrete LLC · Liberty, KYBuilt 1973 · S/N 28R-7335158 N16531Bethge Wade K · Paxinos, PABuilt 1973 · S/N 28R-7335159 N16554Sk Group LLC · Moore, SCBuilt 1973 · S/N 28R-7335162 N16555Vampola Timothy D · Bellevue, NEBuilt 1973 · S/N 28R-7335163 N16566Schaumberg John · Lebanon, INS/N 28R-7335164 N165LHRochester Air Center LLC · Canandaigua, NYBuilt 2011 · S/N 2844144 N1663HSecure Uicc Corp · Glen Burnie, MDS/N 28R-7737007 N166SPSwitzer James DBA · Costa Mesa, CABuilt 1964 · S/N 26-79 N1671HBarth Samuel · Fonda, NYS/N 28R-7737008 N1680HShimkus Aviation LLC · Tupelo, MSS/N 28R-7703031 N1691HButterfield Arthur W Jr · Holland, MIS/N 28R-7703032 N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150

Back to AD 97-01-01 R1