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.

N441TSRawareo LLC · Warsaw, MOBuilt 1966 · S/N 17254288 N44200Cessna172 LLC · Holliday, TXBuilt 1956 · S/N 28127 N4420LMic Jack LLC · Stuart, FLFirst renewal noticeBuilt 1966 · S/N 17254507 N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167 N4421LSouthern Seaplane Inc · Belle Chasse, LAS/N 17254508 N4422RN4422r LLC · Miami, FLBuilt 1974 · S/N 17263168 N4423LQuigley James J · Labelle, FLBuilt 1966 · S/N 17254512 N4423QObap · Westchester, ILBuilt 1973 · S/N 17261704 N4424LTikiun Thaddeus J Jr · Bethel, AKBuilt 1966 · S/N 17254513 N4427LHatter Ronnie A · Newcastle, OKBuilt 1966 · S/N 17254516 N4427RRedwood Aviation Group LLC · Santa Rosa, CABuilt 1974 · S/N 17263173 N4429QDyberg Mike DBA · Mount Vernon, WABuilt 1973 · S/N 17261708 N4429RMacoupin Flyers Inc · Hettick, ILBuilt 1974 · S/N 17263174 N442CROklahoma Aviation LLC · Bethany, OKBuilt 2015 · S/N 172S11519 N442ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12029 N442HBAirborne LLC · Wilmington, DEBuilt 1975 · S/N 17265246 N442KSChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12514 N442PGLuedders & Reed Inc · Pawnee City, NEBuilt 1966 · S/N 17254799 N4430LDunn Michael P · Queen Creek, AZS/N 17254519 N4430RDunder Neil DBA · Cicero, INBuilt 1974 · S/N 17263175 N4431QGraham Huber L · Gulf Breeze, FLBuilt 1973 · S/N 17261710 N4431RRaritan Valley Flying School · Princeton, NJBuilt 1974 · S/N 17263176 N4432RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263177 N4433QTwo Dog Enterprises Inc · Madison, WIBuilt 1973 · S/N 17261712 N4434QFaires Kelly C · Cedartown, GABuilt 1973 · S/N 17261713 N4434RAll American Aviation LLC · Fort Worth, TXBuilt 1974 · S/N 17263179 N4436LLehman Bradley R · Onsted, MIBuilt 1966 · S/N 17254527 N4436QVan Hoomissen Thomas J · Anchorage, AKS/N 17261715 N4436RDoran Kenneth J · Twisp, WABuilt 1974 · S/N 17263181 N4437LThomas John · Lees Summit, MOBuilt 1966 · S/N 17254528 N4438LHarvey Jason Kyle · Glendale, AZS/N 17254529 N443EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12644 N443KSKent State University · Stow, OHBuilt 2020 · S/N 172S12473 N4441LKwon Andrew W · Tujunga, CABuilt 1966 · S/N 17254534 N4441RAtwood Flying Club · Atwood, KSBuilt 1974 · S/N 17263184 N4442FRegistration Pending · Sulphur, LARegistration pendingBuilt 1958 · S/N 46144 N4442LSchoepflin Robert D · Palouse, WABuilt 1966 · S/N 17254535 N4443LHenderson Michael Trustee · Whitman, NES/N 17254536 N4446LC And T Aviation Inc · Madera, CAS/N 17254539 N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188 N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719 N4448LPuertolas Pascual G · Cobb, CABuilt 1966 · S/N 17254541 N444EEVaughn Stewart C · West Jordan, UTBuilt 1974 · S/N 17263906 N444FLAeroflyin Corp · Miramar, FLS/N 17268861 N444FRRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11577 N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013 N444PPCoyne Greg · Hondo, TXBuilt 1969 · S/N 17258278 N444TF4tf LLC · Missoula, MTBuilt 1959 · S/N 46907 N444THAtlas Aviation Tampa Inc · Tampa, FLBuilt 2020 · S/N 172S12440 N444TJWerner Michael H · Edmond, OKBuilt 1979 · S/N 17272953

Back to AD 90-06-03 R1