Skip to content

Registered aircraft · 20,681

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N135PJAviator Air Operations LLC · Grand Prairie, TXBuilt 2000 · S/N 172S8406 N135VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281192 N13601Szuminski Gary F · Palm City, FLBuilt 1974 · S/N 17262873 N13602Dury Vernon E II · Hurst, ILBuilt 1974 · S/N 17262874 N13604Kadlec Ron · Roscoe, SDBuilt 1974 · S/N 17262876 N13605Bolinger Keith · Manheim, PABuilt 1974 · S/N 17262877 N1360ETuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1978 · S/N 17270968 N13611Stitt Gordon C · Saint Germain, WIBuilt 1974 · S/N 17262883 N13618Janzen Royce D · Henderson, NEBuilt 1974 · S/N 17262886 N13619Cougoule Cynthia · Hollister, CABuilt 1974 · S/N 17262887 N1361FWorld Media Corp · Hialeah, FLBuilt 1966 · S/N 17254856 N1361MLux Aero Operations LLC · Belmont, CABuilt 2005 · S/N 172S9842 N1361YFeathered Flyers LLC · Louisville, KYS/N 17249061 N13623Cloer Mark Flynt Sr · Madison, MSBuilt 1974 · S/N 17262890 N1362YKansas State University · Salina, KSFirst renewal noticeBuilt 1961 · S/N 17249062 N13633Zanley William · Fraser, MIBuilt 1974 · S/N 17262894 N13635Hartnett Richard James · Preston, CTBuilt 1974 · S/N 17262896 N13639Bishop Services LLC · Ellisville, MSS/N 17262900 N1363YDrobnis Adam R · Dickson, TNBuilt 1961 · S/N 17249063 N13644Kelley Aircraft LLC · Weyers Cave, VABuilt 1974 · S/N 17262904 N13645Pigg Brian S · Morris, ILBuilt 1974 · S/N 17262905 N13646Menfi Joseph · Hopedale, MABuilt 1974 · S/N 17262906 N1364FLewis David N · Carmel, INBuilt 1966 · S/N 17254859 N1364UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267035 N13658Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1974 · S/N 17262918 N13659Pilot Instructional Center LLC · Kansas City, MOBuilt 1974 · S/N 17262919 N1365FHouse Conrad B · Hernando, MSS/N 17254860 N1365UDiaz Efrain F Ortiz · Toa Baja, PRBuilt 1976 · S/N 17267036 N13660Fly Right LLC · Ridgefield, CTBuilt 1974 · S/N 17262920 N13662Grutza Robert J · Maysville, KYBuilt 1974 · S/N 17262922 N13668Red-Tailed Hawks Aviation Academy · Mukilteo, WABuilt 1974 · S/N 17262927 N1366FBenton Joseph C · Hinckley, MNBuilt 1966 · S/N 17254861 N1366UAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1976 · S/N 17267037 N1366YTulsa Turbine & Recip Inc · Tulsa, OKBuilt 1961 · S/N 17249066 N13672Cape Aerial Tours DBA · Chatham, MABuilt 1974 · S/N 17262931 N13674Bentley Robert H · Lockport, ILBuilt 1974 · S/N 17262933 N13675Valz Thomas M · Cleveland, OKBuilt 1974 · S/N 17262934 N1367FMoehn Dennis H · Oshkosh, WIBuilt 1966 · S/N 17254862 N13680Macvicar Angus C · Nantucket, MABuilt 1974 · S/N 17262937 N13682Moynihan Quinn A · Apple Valley, MNBuilt 1974 · S/N 17262939 N13683American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262940 N13684Matyas Martin M · Helena, OHS/N 17262941 N13685Lee Valley Inc · Tekamah, NEBuilt 1974 · S/N 17262942 N13686T Craft Aero Club Inc · Nampa, IDBuilt 1974 · S/N 17262943 N1368URed Baron Flyers · Caledonia, MNBuilt 1976 · S/N 17267039 N13692American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262946 N13693Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17262947 N13696Johnson Mildred J Executor · Boerne, TXBuilt 1974 · S/N 17262950 N13698Park Avenue Group Inc · Stuart, FLBuilt 1974 · S/N 17262952 N1369FHoudelife Aviation LLC · Bixby, OKBuilt 1966 · S/N 17254864

Back to AD 90-06-03 R1