Skip to content

Registered aircraft · 22,413

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

N4815FAir 2 Sea LLC · Martin, TNBuilt 1976 · S/N 28-7715069 N4815LSt Julian Randall R · Botkins, OHBuilt 1967 · S/N 28-4155 N4815TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1972 · S/N 28-7205200 N4816LGodfrey John E · Greensboro, NCBuilt 1967 · S/N 28-4156 N4816SYarbrough Clay Alan · Brownsboro, ALBuilt 1970 · S/N 32-1276 N4816TBulldog Air LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235114 N4817TJoly Paul A · Henderson, NVBuilt 1972 · S/N 28R-7235115 N4818LFischer Denise L · Lake View Terrace, CABuilt 1967 · S/N 28-4158 N4819TJacob Rolando V · Las Vegas, NVBuilt 1972 · S/N 28-7205201 N481AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843747 N481GSSchmidt Grant S · Jamestown, NDBuilt 1973 · S/N 28-7325622 N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062 N4820LFick Paul R · Deansboro, NYBuilt 1967 · S/N 28-4160 N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063 N4821LFlying Rocks LLC · Sparkill, NYBuilt 1967 · S/N 28-4162 N4821S4821s LLC · Ponte Vedra Beach, FLBuilt 1969 · S/N 32-1252 N4822LMonaco Francis Achille · Martinez, GABuilt 1967 · S/N 28-4164 N4822SHolladay Pamela J · Louisville, KYBuilt 1969 · S/N 32-1253 N4823FEden'S Marine LLC · Jensen Beach, FLBuilt 1976 · S/N 28R-7635437 N4823TCrane Kenneth J · Clinton, INBuilt 1972 · S/N 32-7200025 N4824SWilly Jack LLC · Wickenburg, AZBuilt 1970 · S/N 32-1255 N4826SQuill Sean · Hadley, MABuilt 1969 · S/N 32-1257 N4826TSundance Air Services Inc · Alameda, CAS/N 28-7205202 N4827FVictory Lake Marine Inc · Fremont, NES/N 32R-7680479 N4827LDes Moines Flying Club · Indianola, IABuilt 1967 · S/N 28-4170 N4827SMckemy Michael L · Joppa, MDBuilt 1969 · S/N 32-1258 N4828LMcmordie Frank F IV · Dallas, TXBuilt 1967 · S/N 28-4171 N4828SPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1969 · S/N 32-1259 N4828TSun Star Holdings LLC · Binghamton, NYBuilt 1972 · S/N 28-7205203 N4829LHoughton Robert E · North Ferrisburgh, VTBuilt 1967 · S/N 28-4172 N4829TMaples David R · Diamondhead, MSS/N 28-7205204 N482AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843748 N482ASPlatt Drey D · Sahuarita, AZBuilt 1968 · S/N 28-25252 N482CCMitchell Timothy K · Dunnellon, FLBuilt 1967 · S/N 28-4165 N482DRThurston Steven Curtis · Salisbury, NCBuilt 1977 · S/N 32R-7780391 N482DTCavorite Aviation LLC · Lehi, UTS/N 28-8490071 N482FLJacobs Mark W · Browning, MTBuilt 1971 · S/N 28-7125288 N482MBSmith Thomas W · Wall Township, NJBuilt 1984 · S/N 32-8406015 N482PSinsaja Holdings LLC · Sheridan, WYBuilt 1965 · S/N 28-2728 N482STJ & M Holdco LLC · Cookeville, TNBuilt 2008 · S/N 3257482 N4830FRitzman Todd F · Pewaukee, WIBuilt 1976 · S/N 28-7725031 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 N4831SRegistration Pending · Kodiak, AKRegistration pendingBuilt 1969 · S/N 32-1262 N4831TPower Flow Systems Inc · Daytona Beach, FLBuilt 1972 · S/N 28R-7235120 N4833LAdbm LLC · Oldsmar, FLBuilt 1967 · S/N 28-4176 N4834LBell Hubert D · Lewiston, IDBuilt 1967 · S/N 28-4178 N4835LSims Kyle Z · Locust Grove, GAS/N 28-4179 N4835SHolder Jamie · Marionville, MOBuilt 1970 · S/N 32-1264

Back to AD 87-08-08 R3