Registered aircraft · 20,687

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.

N897AFAmeriflyers Of Texas Inc · Addison, TXS/N 172S13543 N897EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12689 N897LPMarcus Air LLC · Plano, TXBuilt 2001 · S/N 172S8897 N8980VSweitz-Air Inc · Stewartstown, PAS/N 17264336 N89811Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1983 · S/N 17276013 N8982VHirsch John K Trustee · Gerald, MOBuilt 1974 · S/N 17264338 N8983BMcguire Zach T · Jasper, MOBuilt 1958 · S/N 36683 N8983VMoon Reagan E · Bossier City, LABuilt 1974 · S/N 17264339 N8984BWhelchel Neil E · Joshua Tree, CABuilt 1958 · S/N 36684 N8986VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264342 N89878Corwin Shawn M · Tucson, AZBuilt 1983 · S/N 17276015 N8987BHoover Rowdy L · Owasso, OKBuilt 1958 · S/N 36687 N8987VPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1974 · S/N 17264343 N8988VWahle Daniel C · Missoula, MTBuilt 1974 · S/N 17264344 N8990BSortomme Jeffrey P · Sacramento, CABuilt 1958 · S/N 36690 N8992VFreeze Otis C · Frankston, TXBuilt 1974 · S/N 17264347 N8993VBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 17264348 N8995BSommerfeld David A · Assaria, KSBuilt 1958 · S/N 36695 N8996BGartrell Kirk W · Amarillo, TXBuilt 1958 · S/N 36697 N8996VBaumgartner Scot W · Colby, WIBuilt 1974 · S/N 17264351 N8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEBuilt 1974 · S/N 17264352 N8998BValles Rick James · Albuquerque, NMS/N 36698 N8999BRacoon Aviation LLC · San Antonio, TXBuilt 1958 · S/N 36699 N899AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2016 · S/N 172S11767 N899JRAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12708 N89KAKenmore Air Harbor LLC · Kenmore, WABuilt 1973 · S/N 17261114 N89LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13585 N89WWAley Jeffrey S II · Granby, COBuilt 1967 · S/N 17255978 N8BAHoffman Schuyler · Brighton, COBuilt 1964 · S/N 17251805 N8FYMacauley Edwin T · White City, ORBuilt 1973 · S/N 17261717 N8QCKaiser Paul A · Juneau, AKBuilt 1972 · S/N 17260864 N8TRAviation Academy LLC · Wichita, KSBuilt 1972 · S/N 17260672 N9002EWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 17272214 N9002HAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265892 N9002RSmith Terry L · Atoka, TNS/N 28597 N9003EBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17272215 N9004WMustang Sally Aviation LLC · Camden, SCBuilt 2010 · S/N 172S11047 N9005HBuffalo Aviation LLC · Royal, NEBuilt 1975 · S/N 17265894 N9009HConnell Flying Service Inc · Decorah, IABuilt 1975 · S/N 17265897 N900CAAtp Aircraft 1 LLC · Wilmington, DEBuilt 1997 · S/N 17280114 N900RSInmon Leon C · Williston, FLS/N 17248585 N900SCCordle Christopher T · Howard, OHBuilt 1964 · S/N 17251349 N9012HLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 17265899 N9014HFlex Air Holdings Inc · Manhattan, KSBuilt 1975 · S/N 17265900 N9017HMeece Harvey T · Somerset, KYBuilt 1975 · S/N 17265901 N901CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8326 N901JWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258779 N901KSMbk Leasing And Consulting LLC · Lakeland, FLBuilt 1985 · S/N 17276273 N901MPMccole Kevin · Brookline, NHS/N 17259565 N901RJMiller James A · Granada Hills, CABuilt 1965 · S/N 17253429

Back to AD 90-06-03 R1