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.

N336JALundquist Eric John Jr · Houston, TXBuilt 2003 · S/N 81392 N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175 N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087 N336NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 120M N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140 N336RABrown Donald B · Virginia Beach, VABuilt 1978 · S/N 3098 N336RVVose Kristin M · Bloomington, ILBuilt 2001 · S/N 60199 N336SBPieternelle J Coffy · Beaumont, TXBuilt 1973 · S/N 28-7305489 N336TAElder Stephen D · Prineville, ORBuilt 2008 · S/N 22562 N33704Jones Clyde B · Crab Orchard, KYS/N L12771 N3370AHospodar Robert P · Georgetown, PAS/N 22-1627 N3370MPetrie Charles W III · Pahala, HIBuilt 1947 · S/N 12-2242 N33711Macveigh Craig A · New Carlisle, OHS/N LB12891 N33713Mccauley John · Pasco, WABuilt 1941 · S/N LB12911 N33715Wdc Enterprises LLC · Beaumont, TXBuilt 1975 · S/N 28-7525231 N33719Wagner Daniel L · Howe, INBuilt 1941 · S/N L12991 N3371BEllis William Cole · Gakona, AKFirst renewal noticeBuilt 1954 · S/N 18-3494 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3371RRs Helicopters Inc · Winter Haven, FLS/N 3371 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N33727Cohran Chuck Earl · Bowdon, GABuilt 1975 · S/N 28-7515358 N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173 N3372BRegistration Pending · Fairbanks, AKRegistration pendingBuilt 1954 · S/N 18-3496 N3372XLeahy David J · Delaware, OHBuilt 1966 · S/N 670028 N3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeBuilt 1960 · S/N 18-7245 N33733Swink Cory A · Gold Hill, NCBuilt 1975 · S/N 28R-7535184 N33734Bauer Aviation LLC · Reese, MIS/N L13261 N33745Hunt Joel P · Berlin, WIBuilt 1975 · S/N 28-7515359 N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175 N3374ASinosky Kendall Ansley · Anchorage, AKS/N 22-1631 N3374BFederico Leonard A · Reno, NVBuilt 1954 · S/N 183502 N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297 N3374TLazy Eight LLC · Kalispell, MTS/N 17700674 N3374XLee Rollin Kim · Panaca, NVS/N 1091 N3374ZKing Paul E · Albany, ORBuilt 1959 · S/N 18-7249 N33750Geek Air LLC · Wilmington, NCBuilt 1975 · S/N 28R-7535187 N33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDBuilt 1975 · S/N 28-7515360 N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176 N33759Flight Time Club LLC · Searcy, ARFirst renewal noticeBuilt 1975 · S/N 28R-7535188 N3375ATatalovich George · Rome, OHS/N 22-1628 N3375MScott Rudee L · Anchorage, AKBuilt 1947 · S/N 12-2224 N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235 N33763Elon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515361 N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178 N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380 N33770Bassett Christopher D · Robbinsville, NCS/N 28R-7535191 N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180 N3377ABuller Wilbur D · Redding, CABuilt 1953 · S/N 22-1632 N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337 N3377XPenalo Garcia William J · Toa Baja, PRBuilt 1966 · S/N 1092

Back to AD 90-04-06 R1