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.

N1452UHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17267119 N1452YBuranen Mark · Wilmington, DEBuilt 1962 · S/N 17249152 N1453UTri-County Flyers LLC · Morgantown, PABuilt 1976 · S/N 17267120 N1453YNava Henry · Santa Ana, CABuilt 1962 · S/N 17249153 N1454UCentennial Flyers · South Jordan, UTBuilt 1976 · S/N 17267121 N1454VColdwell David B · Bowling Green, KYBuilt 1974 · S/N 17263591 N1454YPendergrass Curt E · Saint Petersburg, FLBuilt 1962 · S/N 17249154 N1455VStaples Aviation Inc · Stormville, NYBuilt 1974 · S/N 17263592 N1455YHelm Richard A · Buckeye, AZS/N 17249155 N1456FBeames Delbert A · Visalia, CABuilt 1966 · S/N 17254951 N1456YLeonardi William J · Jamesport, NYBuilt 1962 · S/N 17249156 N1457FAdvanced Aviation LLC · Pontiac, MIBuilt 1966 · S/N 17254952 N1457VSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1974 · S/N 17263594 N1458FMaltby Patrick W · Bath, MIS/N 17254953 N1458VMiles Aviation LLC · Thedford, NEBuilt 1974 · S/N 17263595 N1458YTln Aviation LLC · Stanwood, WABuilt 1962 · S/N 17249158 N1459EN Hollywood Optimist Club Youth & Comm Svc Fndtn · Van Nuys, CABuilt 1978 · S/N 17271007 N1459FGostecnik Gary · Brookshire, TXBuilt 1966 · S/N 17254954 N1459VRegistration Pending · Portsmouth, NHRegistration pendingBuilt 1974 · S/N 17263596 N1459YBriere Mark E · Mims, FLBuilt 1962 · S/N 17249159 N145HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2001 · S/N 172S8745 N145MEAbdelmotal Elsadig · Pearland, TXBuilt 2000 · S/N 172S8429 N145MLKuonen Christopher · Wellsboro, PABuilt 1976 · S/N 17268382 N1460FConrad William A · Freedom, WIBuilt 1966 · S/N 17254955 N1460VCk Leasing Services LLC · Wilmington, DES/N 17263597 N1461EOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271009 N1461UKettle Peter · Fitchburg, MABuilt 1976 · S/N 17267128 N1461YKarpov Vladimir · Raymond, NES/N 17249161 N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430 N1462FLambdin Charles Randall · Wolf Lake, ILBuilt 1966 · S/N 17254957 N1463E1463 Echo LLC · Eau Claire, WIS/N 17271010 N1463FSun Aircraft Management LLC · Ormond Beach, FLBuilt 2005 · S/N 172S9895 N1464CEdb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S9897 N1464ERegistration Pending · New Windsor, NYRegistration pendingBuilt 1978 · S/N 17271011 N1465EDandelion Wine LLC · Charleston, SCBuilt 1978 · S/N 17271012 N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444 N1466FGoody Birds LLC · Prattville, ALBuilt 1979 · S/N 17273005 N1466UConcepcion Leonardo · Downey, CAS/N 17267133 N1466VGak Flight LLC · Scandia, MNBuilt 1974 · S/N 17263603 N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446 N1468VMonmouth Flying Club · Monmouth, ILBuilt 1974 · S/N 17263605 N146TCN146tc LLC · Minneapolis, MNBuilt 2002 · S/N 172S9146 N1470UScientific Aerial Imaging Inc · Saint Helena, CABuilt 1976 · S/N 17267137 N1470VGiron Lawrence N · Anchorage, AKBuilt 1974 · S/N 17263607 N1471EKdrd Holdings LLC · Texas City, TXBuilt 1978 · S/N 17271014 N1471UEast Tenn Pilots Club Inc · Knoxville, TNS/N 17267138 N1472FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273007 N1472PFlight School Of Texas LLC · Wilmington, DEBuilt 2005 · S/N 172S9899 N1472UEbben Robert A · New London, WIS/N 17267139 N1473YPetty James F · Crandall, GABuilt 1962 · S/N 17249173

Back to AD 90-06-03 R1