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.

N84645In The Grey Aviation LLC · Seadrift, TXFirst renewal noticeS/N 0380 N84647Falcons Aloft LLC · Friday Harbor, WABuilt 1969 · S/N 17258560 N8464DRegistered aircraftBuilt 1957 · S/N 18-6163 N8464JIshawooa Air LLC · Cody, WYBuilt 1981 · S/N VAC 175-81 N8464RBarbrie Nicholas J · Pittston, PAFirst renewal noticeBuilt 1966 · S/N 28-22368 N8464WWiedemann Shane L · Ridgecrest, CABuilt 1965 · S/N 28-2702 N8464YTurner Terrance A · Anchorage, AKS/N 18-8870 N84656Mitchell Larry Trustee · Kingsland, ARBuilt 1969 · S/N 17258564 N84657Myler Mitchell · Bluffdale, UTBuilt 1969 · S/N 17258565 N84659Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1969 · S/N 17258566 N8465CFlyzone LLC · Mount Laurel, NJBuilt 1976 · S/N 28-7625118 N8465DDame Chris A · Harrisburg, ORBuilt 1995 · S/N 21306 N84662Caverns Consulting LLC · Purcellville, VABuilt 1969 · S/N 17258569 N8466BPaphos Airways LLC · Farmingdale, NYBuilt 1981 · S/N 28-8216063 N8466CBaker Matthew T · Shipman, ILBuilt 1976 · S/N 28-7615110 N8466HOsgood Richard E · Boscawen, NHBuilt 1981 · S/N 28-8290062 N8466LWild Blue Yonder LLC · Lewes, DES/N 17256666 N8466RCoffman Shane · Liberty, INS/N 28-22370 N84678Elizabethtown Flying Service Inc · Elizabethtown, KYBuilt 1969 · S/N 17258573 N8467BAthens Aero Club Inc · Athens, OHBuilt 1981 · S/N 28-8290064 N8467DAlexander Sam · Fair Play, MOBuilt 1957 · S/N 18-6167 N8467RHowe Phillip Brandon · Hendersonville, TNBuilt 1966 · S/N 28-22144 N84686Registered aircraftBuilt 1969 · S/N 17258577 N84688Quad Cities Aero LLC · Bettendorf, IABuilt 1969 · S/N 17258578 N8468DBliss James B · Anchorage, AKBuilt 1962 · S/N 18-6168 N8468LMidstate Aviation 1 LLC · Owosso, MIBuilt 1968 · S/N 17256668 N8468WTailwinds Inc · Clear Spring, MDBuilt 1965 · S/N 28-2707 N84695Pike Mark D · Victorville, CABuilt 1969 · S/N 17258581 N84699Skyknights Of Western Ky Inc · Calvert City, KYBuilt 1981 · S/N 28-8290067 N8469DPeppel Tom · Big Lake, AKBuilt 1957 · S/N 18-6169 N8469HBolter Aviation Inc · Lewisville, TXS/N 28-8216065 N8469LZitko Philip R · Shelby, OHBuilt 1968 · S/N 17256669 N8469TLally Thomas J · Manomet, MABuilt 1981 · S/N 28-8216066 N846DLRodgers William B · Dearing, GABuilt 1969 · S/N 17257927 N846EAkland Konrad R · Missoula, MTBuilt 1997 · S/N 24691 N846LLLindner James F · Williamsburg, MIBuilt 2005 · S/N 11572081 N84717Worldwide Warbirds Inc · Heber City, UTBuilt 1969 · S/N 17258589 N8471CC S & W Aviation Inc · Fall Branch, TNS/N 28-7690142 N8471RWright Richard L Jr · Flower Mound, TXBuilt 1966 · S/N 28-22376 N8471SReigle Daniel F · Crown City, OHBuilt 1981 · S/N 28-8216071 N8471TGorman Aviation LLC · Bartlesville, OKBuilt 1981 · S/N 28-8290071 N84721Tail Aero Corp · Wilmington, DES/N 17258591 N8472DKennedy Jared W · Cordova, AKBuilt 1957 · S/N 18-6177 N8472WInfinite Air Center LLC · Albany, ORS/N 28-2714 N8473BWrightsville Aviation Partners LLC · Wilmington, NCS/N 28-8290070 N8473EBeck Roger M Trustee · Goode, VABuilt 1979 · S/N 17272208 N8473RJones Kerry A · Sand Springs, OKBuilt 1966 · S/N 28-22379 N8473UGerding Timothy A · Philomath, ORBuilt 1964 · S/N 17252373 N8473WSimsbury Aviation Services LLC · Simsbury, CTS/N 28-2715 N84740Dark River Capital LLC · Lebanon, OHBuilt 1969 · S/N 17258598

Back to AD 79-10-03 R2