Skip to content

Registered aircraft · 20,683

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.

N622EFEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12821 N622GPTwenty Two Ashford LLC · Brentwood, TNBuilt 1981 · S/N 17274593 N6230DUsda Aphis Wildlife Services · Cedar City, UTBuilt 1979 · S/N 17272648 N6230EDean Matthew · Pine Grove, CAS/N 46330 N6231EMiller Edward P · Northfield, MNBuilt 1978 · S/N 17272001 N6231FH & F Aviation Inc · Labelle, FLS/N 17273170 N6232DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272650 N62332Skylens LLC · Hammond, LABuilt 1981 · S/N 17275251 N6233DGrauert Ritter Trustee · Van Nuys, CAS/N 17272651 N62348Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275254 N62350Flycarolina LLC · Concord, NCBuilt 1981 · S/N 17275255 N62354Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275256 N6235ELee William Lewis · Gilbert, AZS/N 46335 N6235TCrystal Air Inc · Chattanooga, TNBuilt 2008 · S/N 17281515 N6237ESale Reported · Brandon, MSSale reportedS/N 46337 N6238AExecutive Flight Institute LLC · Murrieta, CABuilt 2008 · S/N 172S10702 N6239DAerial Precision LLC · Entiat, WAS/N 17272657 N6239EKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1958 · S/N 46339 N6239FEckert Ted · Cedar Creek, TXBuilt 1979 · S/N 17273172 N623EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13097 N623HBRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12397 N623KWLanier Equipment Leasing LLC · Gainesville, GABuilt 2013 · S/N 172S11269 N623SPAtp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 172S8614 N62405Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17275263 N62407Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275264 N6240EDgcg Properties LLC · Casa Grande, AZBuilt 1959 · S/N 46340 N6241ERuijne Leo L · Plainview, TXS/N 46341 N62425Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 17275267 N62429Fowler Cary D · Hayti, MOBuilt 1981 · S/N 17275268 N6242EDenson Randy A · Meridian, IDBuilt 1958 · S/N 46342 N6242FAzul Services LLC · Bozeman, MTBuilt 2008 · S/N 172S10701 N62444Ditmer Jack L Jr · Troy, OHBuilt 1981 · S/N 17275271 N62447Tri-State Flg Club Inc · Huntington, WVBuilt 1981 · S/N 17275272 N6244ESpicer Aaron D · Wadena, MNBuilt 1958 · S/N 46344 N62457Pisarello William J · Sebring, FLBuilt 1981 · S/N 17275275 N6245BInternational Air Services Inc Trustee · Carson City, NVS/N 172S8318 N6245CWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 172S10723 N6245DJeffery & Weiss Holdings LLC · Long Beach, CABuilt 1979 · S/N 17272661 N6245EDirty Side Down Aviation LLC · Georgetown, TXBuilt 2000 · S/N 172S8674 N62475Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275279 N6247EBudenbender Heidi B · Weatherford, TXBuilt 1959 · S/N 46347 N62486486 Aviation LLC · Worthington, OHBuilt 1981 · S/N 17275280 N62487Flying Nam LLC · Sheridan, WYS/N 17275281 N62488Leaf Air LLC · Queensbury, NYBuilt 1981 · S/N 17275282 N6248DEscobar Frank · Tampa, FLBuilt 1979 · S/N 17272663 N6249ERlp Aviation LLC · Missoula, MTBuilt 1959 · S/N 46349 N6249VN6249v LLC · Park Ridge, ILBuilt 1980 · S/N 172RG0596 N624BBravo Aircraft LLC · Alpharetta, GABuilt 2025 · S/N 172S13347 N62502Hill Andrew T · Smithville, TXS/N 17275284 N62503Back Forty Flying Club Inc · Roanoke, INBuilt 1981 · S/N 17275285

Back to AD 90-06-03 R1