Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N4808LGifford Jerald O · Idaho Falls, IDS/N 28-4147 N4809LLuxl Frank S · Wilmington, DEBuilt 1967 · S/N 28-4148 N4810ADecker Richard A · Onalaska, WABuilt 1956 · S/N 22-3962 N4810GAndrecheck Cynthia R · Bethel, AKBuilt 1979 · S/N 17273358 N4810LLove James Matthew Maynard · Brighton, MIBuilt 1967 · S/N 28-4149 N4810UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842227 N4811AJacobs Eric R · Bozeman, MTBuilt 1956 · S/N 22-3963 N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1979 · S/N 17273359 N4811JSeals Kenneth P · Munford, ALBuilt 1979 · S/N 17273681 N4812LPalmer Xavier · Moreno Valley, CABuilt 1967 · S/N 28-4151 N4812TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 28-7225211 N48130Estes Johnny C · Senoia, GABuilt 1976 · S/N 76 N4813AVon Etten Robert P · Ravena, NYBuilt 1956 · S/N 22-3965 N4813CCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276505 N4813GBasso Michele · Millbrook, ALBuilt 1979 · S/N 17273361 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

Back to AD 79-10-03 R2