Skip to content

Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N4830ARenick Tyler Cain · Wichita Falls, TXS/N 22-3983 N4830FRitzman Todd F · Pewaukee, WIBuilt 1976 · S/N 28-7725031 N4830GHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 17273378 N4830LOne Niner Right Ltd · Bartlett, ILBuilt 1967 · S/N 28-4173 N4830UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842236 N4831LMartinez Custom Homes LLC · Porter, TXBuilt 1967 · S/N 28-4174 N4832ESenn David L · Oak Ridge, TNBuilt 1959 · S/N 7GC-40 N4833LAdbm LLC · Oldsmar, FLBuilt 1967 · S/N 28-4176 N4834ARegistration Pending · Eagle River, WIRegistration pendingBuilt 1956 · S/N 22-3987 N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670 N4834LBell Hubert D · Lewiston, IDBuilt 1967 · S/N 28-4178 N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383 N4835LSims Kyle Z · Locust Grove, GAS/N 28-4179 N4835TPero Thomas E · Richland, MIBuilt 1972 · S/N 28-7225218 N4836ASales Joe Haney · Seminole, TXS/N 22-3989 N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384 N4836LPeterson Wayne · Dexter, MNBuilt 1967 · S/N 28-4180 N4837FWesellairplanes Com Inc · Wilmington, DEBuilt 1976 · S/N 28-7715071 N4837LNavarro Ricky L · Riverview, FLBuilt 1967 · S/N 28-4181 N4838Fajardo Mark A · Longmont, COBuilt 1975 · S/N KB-1 N4838FThomason Booker T Jr · Chicago, ILBuilt 1976 · S/N 28-7715072 N4838LSandstrom David E · Anchorage, AKBuilt 1967 · S/N 28-4182 N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386 N4839LStandard David W · Toccoa, GABuilt 1967 · S/N 28-4183 N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012 N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99 N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688 N483FLOliver Zachary J · Seligman, AZBuilt 1971 · S/N 28-7125291 N4840LIrons Eric P · Enoch, UTBuilt 1967 · S/N 28-4186 N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371 N4841FVidhun Raghuraman R · Southbury, CTBuilt 1976 · S/N 28-7790067 N4841LPapa India Echo Inc · Chambersburg, PABuilt 1967 · S/N 28-4187 N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995 N4842THampsten Jacob Clay · Mesquite, NVS/N 28-7225222 N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996 N4843THuizenga Jamie L · Pierre, SDBuilt 1972 · S/N 28-7205205 N48443Christian James B · Peyton, COBuilt 1943 · S/N 122 N4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeBuilt 1979 · S/N 17273088 N4844JSkoglun Eric W · Cashmere, WABuilt 1979 · S/N 17273684 N4844LHoover Liston LLC · Riverton, UTBuilt 1967 · S/N 28-4190 N4844TKings Wings LLC · East Wenatchee, WABuilt 1972 · S/N 28-7205206 N4845AParenteau William · Maple Grove, MNBuilt 1910 · S/N 22-3998 N4845GNation Linda S · Sanford, FLBuilt 1979 · S/N 17273392 N4845JL&J Aviation Inc · Atwater, CABuilt 1979 · S/N 17273685 N4845SSt Cloud Flying Group LLC · Richmond, MNBuilt 1971 · S/N 28-7125381 N4846GNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1979 · S/N 17273393 N4846LCoggins Beau · Alpine, TXBuilt 1967 · S/N 28-4379 N4847GFlying Daze · Batavia, OHBuilt 1979 · S/N 17273394 N4847LKulwicki Gary Andrew · Seffner, FLBuilt 1967 · S/N 28-4192 N4849AVeblen Raak · Auburn, CABuilt 1956 · S/N 22-4002

Back to AD 80-04-03 R2