Skip to content

Registered aircraft · 40,394

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.

N8957CTracon Aviation LLC · Winter Springs, FLBuilt 1976 · S/N 28-7625137 N8957JAirplane LLC · Farmington, UTBuilt 1965 · S/N 28-2978 N8957VN8957v LLC · Fort Lauderdale, FLBuilt 1974 · S/N 17264313 N8958English John H · Pittsburg, TXBuilt 1973 · S/N 610-74 N8958CWinter John T · Tucson, AZBuilt 1976 · S/N 28-7625138 N8958DPoulton Daniel D · Belton, SCBuilt 1958 · S/N 226121 N8958JDavis William M · New Lenox, ILBuilt 1966 · S/N 28-2979 N8958VHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264314 N89594Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17276009 N8959JRegistration Pending · Fairmont, WVRegistration pendingS/N 28-2980 N895VSpurlock Ricky DBA · Jensen, UTBuilt 1958 · S/N 18-6736 N8960CChristensen Todd S · Wasilla, AKBuilt 1954 · S/N 18-3261 N8960JRegistered aircraftFirst renewal noticeBuilt 1965 · S/N 28-2982 N8961CHuguenard Jefferson · Alpharetta, GABuilt 1976 · S/N 28-7615135 N8961VHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17264317 N8961ZHein-Reece Linda K · Shelton, WABuilt 1973 · S/N 17262110 N8962JStory Allen D · Arlington, TXBuilt 1965 · S/N 28-2984 N8963DDoyle Patrick H · Keller, TXBuilt 1958 · S/N 22-6127 N8964DThomas Daniel C · Shady Shores, TXBuilt 1958 · S/N 22-6128 N8964JKemper Kevin K · Granite Bay, CABuilt 1992 · S/N 028 N8964VOneill Jared · Gilroy, CABuilt 1974 · S/N 17264320 N8965DSale Reported · Beech Creek, PASale reportedBuilt 1958 · S/N 22-6129 N8965JN8965j LLC · Anchorage, AKBuilt 1966 · S/N 28-2987 N8966DDodd Robert L · Humboldt, IABuilt 1958 · S/N 22-6130 N8966JBrown Bradford K · Leoti, KSBuilt 1965 · S/N 28-2988 N8966VCreider Paul E · Tulsa, OKBuilt 1974 · S/N 17264322 N8967JJust Plane Fun LLC · Sunrise, FLBuilt 1965 · S/N 28-2990 N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209 N8968DCleary Katherine E · Mulberry, FLBuilt 1958 · S/N 22-6132 N8968JStevens Raymond W · Norfolk, VAS/N 28-2991 N8968VLittle Gordon D · Watertown, SDS/N 17264324 N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173 N896AKQuadcub Utah LLC · Salt Lake City, UTS/N 1 N896B49 Holdings LLC · Cheyenne, WYBuilt 2021 · S/N MB27 N896SCHansen Ernest F · Sequim, WABuilt 2020 · S/N 001 N8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993 N8970VWinding Creek Aviation LLC · Snellville, GABuilt 1974 · S/N 17264326 N8971DThomas James W · Jay, FLBuilt 1958 · S/N 18-6408 N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994 N8971VGibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264327 N89721Propability One LLC · Daytona Beach, FLBuilt 1983 · S/N 17276010 N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174 N8972DClarke Timothy B · Howard, SDBuilt 1958 · S/N 18-6411 N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995 N8972VPearce Michael J · Phoenix, AZBuilt 1974 · S/N 17264328 N8973DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6412 N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996 N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329 N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331 N8976DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-4887

Back to AD 79-10-03 R2