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.

N4813LFitzgerald Timothy R · San Antonio, TXBuilt 1967 · S/N 28-4152 N4814CKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275868 N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366 N4814TRobertson Roland L · Meridian, IDBuilt 1972 · S/N 28-7205199 N4815CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276453 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 N4816ASullivan Phillip M · Louisville, KYS/N 22-3969 N4816LGodfrey John E · Greensboro, NCBuilt 1967 · S/N 28-4156 N4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388 N48187Nelson Lynn D · New Waverly, TXBuilt 1976 · S/N 26 N4818ACampbell Allen G · Sault Sainte Marie, MIBuilt 1956 · S/N 22-3971 N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367 N4818LFischer Denise L · Lake View Terrace, CABuilt 1967 · S/N 28-4158 N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367 N4819TJacob Rolando V · Las Vegas, NVBuilt 1972 · S/N 28-7205201 N481ACVogel Lawrence O · Gig Harbor, WAS/N 1289-2000 N481DMEdgewood Capital LLC · Joplin, MOBuilt 2001 · S/N 1307-2001 N481EMClark Jeffrey V · Libertyville, ILBuilt 1996 · S/N 375-96 N481GSSchmidt Grant S · Jamestown, NDBuilt 1973 · S/N 28-7325622 N481MASlavens Timothy W · Howard City, MIBuilt 2003 · S/N 441-2003 N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369 N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062 N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368 N4820LFick Paul R · Deansboro, NYBuilt 1967 · S/N 28-4160 N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974 N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063 N4821LFlying Rocks LLC · Sparkill, NYBuilt 1967 · S/N 28-4162 N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370 N4822LMonaco Francis Achille · Martinez, GABuilt 1967 · S/N 28-4164 N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391 N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372 N4825ATodd Gary W · Rogers, OHBuilt 1956 · S/N 22-3978 N4826TSundance Air Services Inc · Alameda, CAS/N 28-7205202 N4827LDes Moines Flying Club · Indianola, IABuilt 1967 · S/N 28-4170 N4828LMcmordie Frank F IV · Dallas, TXBuilt 1967 · S/N 28-4171 N4828TSun Star Holdings LLC · Binghamton, NYBuilt 1972 · S/N 28-7205203 N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377 N4829LHoughton Robert E · North Ferrisburgh, VTBuilt 1967 · S/N 28-4172 N4829TMaples David R · Diamondhead, MSS/N 28-7205204 N482ACClarke Jonathan Eric · Eustace, TXBuilt 1999 · S/N 428-99 N482AMWarner Robins Air Service · Cochran, GABuilt 2004 · S/N 2282 N482ASPlatt Drey D · Sahuarita, AZBuilt 1968 · S/N 28-25252 N482CCMitchell Timothy K · Dunnellon, FLBuilt 1967 · S/N 28-4165 N482DTCavorite Aviation LLC · Lehi, UTS/N 28-8490071 N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338 N482EJDavis Douglas L · Everson, WABuilt 1953 · S/N 20-1052 N482FLJacobs Mark W · Browning, MTBuilt 1971 · S/N 28-7125288

Back to AD 80-04-03 R2