Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N25557All Aviation Xp LLC · Parkland, FLBuilt 1977 · S/N 15280729 N2555BHadden Fleming Cindy L · San Antonio, TXS/N 28-25678 N2555MSchiller Jeffrey A · San Diego, CABuilt 1946 · S/N 12-1011 N2555PJohnson Alwyn J · Karlstad, MNBuilt 1955 · S/N 22-2889 N25561Hendrickson Flying Service Inc · Rochelle, ILBuilt 1975 · S/N TC-TWH-1 N25564Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280732 N25567Ellingwood Kevin J · Williamstown, MABuilt 1977 · S/N 15280735 N2556AAllen Trace L · Hurricane, UTBuilt 1952 · S/N 22-853 N2556MTennyson Chad E · Ridgefield, WABuilt 1946 · S/N 12-1040 N25572Gruetzmacher Marcus Darren · Goliad, TXBuilt 1977 · S/N 15280738 N25573Adjoodani Farhad F · Glen Burnie, MDBuilt 1977 · S/N 15280739 N25575Pierce John S · Delevan, NYBuilt 1977 · S/N 15280741 N2557AHubbard Byron R · Cleburne, TXBuilt 1952 · S/N 22-855 N2557MSale Reported · Oklahoma City, OKSale reportedBuilt 1946 · S/N 12-934 N2557PMcmahon Thomas F · Yakima, WABuilt 1955 · S/N 22-2920 N2557WAndre Norman C · Downers Grove, ILBuilt 1965 · S/N 923 N25582Heavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15280746 N25585Morsch William J Jr · Hempstead, NYRegistration revokedBuilt 1940 · S/N 685 N25586Christensen Grant Eric · Santa Maria, CAS/N 686 N2558LHoecher Robert · Anchorage, AKS/N 17255758 N25596Phelps Charles R · Princeton, KYS/N 38-81A0009 N2559AStefan Leon F · Nickerson, KSBuilt 1952 · S/N 22-857 N2559PSale Reported · Oklahoma City, OKSale reportedBuilt 1955 · S/N 22-2922 N2559STrue Altitude LLC · Isola, MSBuilt 1979 · S/N 18-7909160 N2559WHighfill Randall W · Hannibal, MOBuilt 1965 · S/N 3268 N255CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881390 N255JSFalcon Helicopters Inc · Logan, NMS/N 364 N255LLChandler Elijah J S · Pilot Mountain, NCS/N 082 N255PCWinger Michael J · Boulder Junction, WIBuilt 2002 · S/N 5173 N255SCSouth Georgia Technical College · Americus, GABuilt 2005 · S/N 3772 N255SFKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 1287-2000 N255SKParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020130 N255TJVolar II LLC · Edmond, OKBuilt 2016 · S/N 4496394 N255WYWagner John W · Boise, IDBuilt 2015 · S/N 3255 N255XKnop Courtney Dee · Vernal, UTS/N 20450 N25604Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 15280762 N25608Smith Boyd · Goshen, INBuilt 1977 · S/N 15280764 N2560MAicraft Leasing LLC · Orlando, FLBuilt 1946 · S/N 12-936 N2560NMcquack Aviation LLC · Belding, MIBuilt 1979 · S/N 38-79A0913 N2560PBader Regan R · Saint Libory, NEBuilt 1955 · S/N 22-2923 N2560WManasseh Medical Imaging Inc · Lubbock, TXS/N 924 N25610Painter Bryan · Renton, WABuilt 1977 · S/N 15280766 N2561WStaker Bryan P · Pleasanton, CAS/N 925 N2561ZMcbride Steve · Shamong, NJBuilt 1977 · S/N 353-77 N25623Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1981 · S/N 38-81A0048 N2562FMans David A · Gruver, TXBuilt 1965 · S/N 35 N2562KPodany John R · Aledo, TXBuilt 1988 · S/N 922 N2562UJust Plane People LLC · Irvine, CABuilt 1979 · S/N 28-8090056 N2563DBeckhoff Allen C · Greybull, WYBuilt 1978 · S/N 38-79A0376 N2563FHickey Michael · Honey Grove, TXBuilt 1966 · S/N 137

Back to AD 90-04-06 R1