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.

N1369QAmeriflyers Of Texas Inc · Addison, TXBuilt 2005 · S/N 172S9946 N1369YMadden James D · Sharpsburg, GABuilt 1961 · S/N 17249069 N136HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9711 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N136VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281193 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953 N13703Kisser Carroll P · Alexandria, VABuilt 1974 · S/N 17262955 N1370ESprocket Aircraft Management LLC · Kennesaw, GABuilt 1978 · S/N 17270972 N1370UUnited States Air Force Aero Club · Usaf Academy, COBuilt 1976 · S/N 17267041 N13715Wingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17262962 N13719Precious Metal Aviation LLC · Menomonee Falls, WIBuilt 1974 · S/N 17262966 N1371FJones Michael Robert · Glen Rose, TXS/N 17254866 N1371UStanton Sport Aviation · Stanton, MNBuilt 1976 · S/N 17267042 N1371YFlightsuit Farmer LLC · Imperial, NEBuilt 1961 · S/N 17249071 N13721Muth Robert F · Whitefish, MTBuilt 1974 · S/N 17262968 N13723Johnson Darwin E Jr Trustee · Hollywood, ALBuilt 1974 · S/N 17262970 N13725Moster Paul C · Morristown, NJBuilt 1974 · S/N 17262972 N13727Ofarrell Scott A · Sterling Heights, MIBuilt 1974 · S/N 17262973 N1372ECsa Aircraft Leasing LLC · Park City, UTS/N 17270974 N1372UFerguson Joseph L II · Fairmont, WVBuilt 1976 · S/N 17267043 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13748Ries Farms LLC · Hastings, MNS/N 17262989 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1374FHegge Luke T · Pine City, MNBuilt 1966 · S/N 17254869 N1374USkydance Aviation LLC · Norfolk, VABuilt 1976 · S/N 17267045 N1374YBowden Richard P · Lenexa, KSBuilt 1961 · S/N 17249074 N13751Stegmaier Ann C · Eagan, MNBuilt 1974 · S/N 17262992 N13752Coffman Aviation Inc · Jacksonville, FLBuilt 1974 · S/N 17262993 N13753Reeves Christopher A · Statesville, NCBuilt 1974 · S/N 17262994 N13754Durrum Frank D III · Mount Pleasant, TXBuilt 1974 · S/N 17262995 N1376FWerderich George A · Bartlett, ILBuilt 1966 · S/N 17254871 N13770Countryside Academy · Benton Harbor, MIBuilt 1974 · S/N 17263001 N13778Weitekamp Shawn Paul · Roanoke Rapids, NCBuilt 1974 · S/N 17263003 N1377EFly Barely LLC · Manitowoc, WIBuilt 1978 · S/N 17270978 N1377FMartinelli James · Madras, ORBuilt 1966 · S/N 17254872 N1377MBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260577 N1377SUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2005 · S/N 172S9840 N1377UWifa (Washington International Flight Academy) LLC · Wilmington, DEBuilt 1976 · S/N 17267048 N13786Diapaola Anthony Sr · New Eagle, PABuilt 1974 · S/N 17263004 N1378MCavok LLC · La Vergne, TNBuilt 1972 · S/N 17260578 N13796Positive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263006 N1379UHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17267050 N137ALLegends Air Center LLC · Bentonville, ARBuilt 1976 · S/N 17268125 N137CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13486

Back to AD 90-06-03 R1