Skip to content

Registered aircraft · 2,261

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-02-05') 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-02-05') 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-02-05')
    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-02-05')
  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-02-05')
  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-02-05')
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.

N1007LPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-7703403 N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310 N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081 N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079 N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049 N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135 N104FGWilson Conrad · Bowdon Junction, GAS/N 28-7716292 N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115 N1056HBrown Danny Joe · Skidmore, MOS/N 28R-7703011 N106PESheboygan Flying Club LLC · Sheboygan, WIBuilt 1977 · S/N 28R-7837088 N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251 N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214 N108NDMavity Michael D · Phoenix, AZBuilt 1990 · S/N 2841328 N1090QArrow 051 LLC · Leicester, NCBuilt 1977 · S/N 28R-7703051 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109KBWings Aviation Inc · Valparaiso, INBuilt 1978 · S/N 28R7803043 N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189 N1118QAscend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716083 N111WMMoore Forrest · Liberty Hill, TXBuilt 1978 · S/N 28R-7837159 N1128QZastrow Andrew S · Knoxville, TNBuilt 1977 · S/N 28R-7737027 N112TPHarper Gary B · Fitzgerald, GABuilt 1977 · S/N 28-7716289 N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053 N113VKHaskell Brenton · Georgetown, KYBuilt 1978 · S/N 28R-7803352 N1140QLuken Henry G III · Chattanooga, TNS/N 28-7716086 N1168HKoplow Steve Alan · Sevierville, TNS/N 28R-7703015 N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094 N116FRCloverfield Aero LLC · Los Angeles, CABuilt 2014 · S/N 2844150 N117MBLittmarck Svante · Dedham, MABuilt 2014 · S/N 2844151 N117SCJenkins Matthew A · Bend, ORS/N 28R-7703343 N1190HBergman William George · Muskegon, MIBuilt 1977 · S/N 28-7716002 N1194HCrnic Paul C · Chesterfield, MOS/N 28R-7703016 N11CWJabez Aviation LLC · Petaluma, CABuilt 1977 · S/N 28R7737079 N11RPN11rp LLC · Brecksville, OHBuilt 1978 · S/N 28R-7803241 N11RRRichardson Randy R · St Thomas, VIS/N 28R-7803076 N121FTBowman William K · Raleigh, NCBuilt 1982 · S/N 28-8216191 N121WSOrtiz Ramon E · Spring Branch, TXBuilt 1978 · S/N 28R-7803340 N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266 N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N123DUInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 287716195 N123GKKolis George J · Pennsauken, NJBuilt 1980 · S/N 28-8016359 N123KRRuhlin Thomas J · Lakewood Ranch, FLBuilt 1977 · S/N 28-7716242 N124MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 2844092 N1254HSherer Scott · Franklin, WIBuilt 1976 · S/N 28R-7703018 N125MTMcdonald Theresa C · Beaufort, SCS/N 2844093 N1273HCrabtree Robert E · Lookout Mountain, TNS/N 28R-7703019

Back to AD 79-02-05