Skip to content

Registered aircraft · 68,375

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.

N3427TRodgers Julia D · Orem, UTS/N 17700727 N3427YTradewind LLC · Wasilla, AKBuilt 1962 · S/N 18-7794 N34281Newman Richard T · Everett, WABuilt 1972 · S/N 17701746 N34283Tropical Flying Club LLC · Orlando, FLBuilt 1972 · S/N 17701748 N34284Ladd Michael · Umatilla, FLBuilt 1972 · S/N 17701749 N34285Peterson Scott · Morgantown, WVBuilt 1972 · S/N 17701750 N34286Pierce Ralph Anthony · Lake Mathews, CAS/N 17701751 N34287Satellite Beach Flying Club Inc · Melbourne, FLBuilt 1972 · S/N 17701752 N34288Registration Pending · Lakebay, WARegistration pendingBuilt 1972 · S/N 17701753 N3428RLagrange David F · Winterset, IAS/N 28-5678 N3428TBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeBuilt 1968 · S/N 17700728 N3428ZHefner Ronald J · Plattsmouth, NES/N 22-7341 N3429EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271545 N3429ZWaters Dwayne R · Merritt Island, FLBuilt 1960 · S/N 22-7343 N342BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881650 N342CAEastern Stearman Inc Trustee · Leesburg, VABuilt 1979 · S/N 18-8009005 N342DALewis William R · Temple, TXBuilt 2009 · S/N 91156 N342FGDm Equipment Leasing LLC · Parker, COBuilt 2021 · S/N 28020042 N342GLast Dean H · Mill Creek, WABuilt 1999 · S/N 3679 N342GRSouthern Aero LLC · Homestead, FLBuilt 1972 · S/N 34-7250021 N342HTrautman Michael · Hamilton, MTBuilt 1998 · S/N 1245-98 N342JBCentral Ohio Flyers Association · Columbus, OHBuilt 1968 · S/N 17701033 N342MAStauffer Michael S · Wichita Falls, TXBuilt 1996 · S/N 2843042 N342MCCarra Michael J · Aiken, SCBuilt 2001 · S/N 1701 N342MDCunningham Thomas J · New Braunfels, TXBuilt 2010 · S/N 2504 N342MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 2881260 N342MLOrlowski Michael A · Gold Hill, NCS/N 343 N342PTParker Matthew M · Mesa, AZBuilt 1999 · S/N 101742 N342TAUnited States Air Force 60 Fss/Fsca · Rio Vista, CABuilt 2006 · S/N 2843645 N342WPPapa LLC · Eufaula, ALBuilt 1977 · S/N 28-7716288 N34300Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 177RG0988 N34302Romero John M · College Station, TXBuilt 1972 · S/N 17701757 N34308Greenwood Kevin · Tucson, AZBuilt 1972 · S/N 17701759 N3430NKellner Darlene D · Lancaster, PABuilt 1967 · S/N 680050 N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396 N3430TMeador Phillips H · Lexington, KYBuilt 1968 · S/N 17700730 N34316Dane Ward LLC · Rising Fawn, GABuilt 1972 · S/N 17701764 N34320Eagle Sky Patrol Inc · Deadwood, SDBuilt 1972 · S/N 17701766 N34328Hamilton Thomas Arden · Lovettsville, VABuilt 1972 · S/N 17701767 N3432AHolbrook Joel P · Delta Junction, AKBuilt 1953 · S/N 22-1699 N3432KPorte Elvis · Miami, FLBuilt 1967 · S/N 28-23552 N3432MSears Megan · Rigby, IDBuilt 1977 · S/N 28-7816343 N3433CDiaz James R · Sullivan, OHS/N 26476 N3433MDixon Tom N · Lodi, CABuilt 1947 · S/N 12-2270 N3433PBolgar Mark S · Ewing, NJBuilt 1999 · S/N 420-99 N3433XRundus Timothy A · Chandler, AZBuilt 1966 · S/N 1125 N3433ZKitchen Ronald L · Leasburg, MOFirst renewal noticeBuilt 1960 · S/N 22-7347 N34343Wright Wayne M · Chestertown, MDBuilt 1972 · S/N 17701772 N34346Ball Donald · Hatfield, PABuilt 1972 · S/N 17701774 N34348Pingree Properties LLC · Hampshire, ILBuilt 1972 · S/N 17701775

Back to AD 90-04-06 R1