Registered aircraft · 20,675

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.

N1001MRocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N 17259401 N1002MSchuler Mark E · Columbia, ILBuilt 1970 · S/N 17259402 N10033Thunderfighter LLC · Englewood, COS/N 172S9797 N1004EUnison Air LLC · Palo Alto, CABuilt 2005 · S/N 172S9872 N1004MReid Brian · Boise, IDBuilt 1970 · S/N 17259404 N1006VLanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 172S9805 N1008MHottenstein William R · Kingston, PABuilt 1970 · S/N 17259408 N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479 N100CGGreene Carol W · Mahwah, NJBuilt 1972 · S/N 17261191 N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599 N100KHLefevers Adam · Pineville, KYS/N 28529 N100LED&J Training Planes LLC · Logan, UTBuilt 2023 · S/N 172S13000 N100LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2025 · S/N 172S13292 N100LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280075 N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590 N100PMPegasus Air LLC · Louisville, KYBuilt 2004 · S/N 172S9599 N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551 N100SUOhio State University · Columbus, OHS/N 172S11739 N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499 N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400 N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056 N1011NBlue Skies Aircraft LLC · Zephyrhills, FLBuilt 1970 · S/N 17259525 N1014FPeppard Kenneth W · Dumfries, VABuilt 1979 · S/N 17272931 N1016FFly Cadillac LLC · Tustin, MIS/N 17272932 N1019FFly By Aviation LLC · Sun Valley, CABuilt 1979 · S/N 17272933 N101GVWindward West Inc · Boise, IDBuilt 1998 · S/N 172S8021 N101KSWright Kenneth D · Benton, ARBuilt 1974 · S/N 17263095 N101LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13119 N101LJGrenier Garret P · Anchorage, AKBuilt 1976 · S/N 17267273 N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709 N101RKBlake James R · Marion, LABuilt 1972 · S/N 17261166 N101TFAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12710 N101USUsaeroflight LLC · Greenville, SCBuilt 1972 · S/N 17260922 N101UTRudd James M · Lake Jackson, TXBuilt 1971 · S/N 17259900 N101VKWings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 172S8211 N101WLRegistration Pending · Wichita, KSRegistration pendingBuilt 2026 · S/N 172S13568 N101WSKarnick Mark C · Mesa, AZBuilt 1971 · S/N 17260218 N1023BLeguia Augusto A · Kathleen, GAS/N 28524 N1026MStinar Gary F · Lakeville, MNBuilt 1970 · S/N 17259406 N1027MLoomis Aviation LLC · Gahanna, OHBuilt 1970 · S/N 17259407 N102ACWindfall Capital Ventures LLC · Westerville, OHS/N 17271882 N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552 N102HWDhs Operations LLC · Wilmington, DEBuilt 2001 · S/N 17281058 N102KSKent State University · Stow, OHBuilt 2005 · S/N 172S10091 N102LAIowa Lakes Community College · Estherville, IAS/N 17259038 N102MUTraining Planes LLC · Tampa, FLBuilt 1997 · S/N 17280285 N102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462 N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570 N1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238 N1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 172S10598

Back to AD 90-06-03 R1