Skip to content

Registered aircraft · 85,612

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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  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:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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.

N2935LCrc Medical Staffing Inc · Mansfield, LAS/N 670069 N2935NMartineau Robert Tyler · Crested Butte, COBuilt 1979 · S/N 28-7990562 N2935SJacksonville Airport Authority · Jacksonville, ILBuilt 1979 · S/N 28-7990563 N2935UBraner Richard C · Oakdale, CABuilt 1979 · S/N 28-7990565 N2935VHungerford Mark T · Swanton, VTBuilt 1979 · S/N 28-7990566 N29361Blomgren Roy E · Woodstock, ILS/N 28-7911176 N2936CSale Reported · Stoughton, WISale reportedBuilt 1954 · S/N 30836 N2936DKrish Air LLC · Louisville, KYBuilt 1955 · S/N 26879 N2936EHansen Mark A Trustee · Long Beach, CABuilt 1975 · S/N 18052562 N2936LWencko Paul Andrei · Saint Petersburg, FLBuilt 1967 · S/N 670070 N2936NTailwinds Aviation LLC · Crystal Lake, ILBuilt 1979 · S/N 28R-7918229 N2936QA&J Aircraft Leasing Inc · Burlington, COS/N 28-7716126 N29374Heartland Aviation Inc · Alliance, NEBuilt 1979 · S/N 28-7911178 N29376Registered aircraftBuilt 1979 · S/N 28-7911179 N2937BHaas Terry D · New Tripoli, PABuilt 1979 · S/N 28R-7931261 N2937DCoffman Robert P · Bigfork, MTBuilt 1954 · S/N 26880 N2937NDelaware State University Aviation Program · Dover, DEBuilt 1979 · S/N 28-7916559 N2937QCharles Sargent Irrigation Inc · Broken Bow, NES/N 28-7716127 N2937RCross Winds Flying Club Inc · Bloomington, ILBuilt 1979 · S/N 28-7916560 N2937UHangar 47 Aviation LLC · Midvale, UTBuilt 1963 · S/N 17250537 N2937XOrtega Tobin W · Juneau, AKBuilt 1979 · S/N 28-7990567 N2937YSkylane Inc · Moose Lake, MNBuilt 1962 · S/N 18253937 N2938AKoons John D · Waterville, MES/N 30138 N2938CKeller Dylan M · Meridian, IDBuilt 1954 · S/N 30838 N2938FFly Gateway Aviation Institute · New Castle, DES/N 28-7990573 N2938LAmend Keith R · Hagerman, IDBuilt 1967 · S/N 670072 N2938UArcher Two Aviation LLC · Walnut Creek, CABuilt 1979 · S/N 28-7990574 N2938YFoster Amy L DBA · Jarrell, TXBuilt 1962 · S/N 18253938 N29394Davis Kenneth Howard · Waxahachie, TXBuilt 1979 · S/N 28-7921033 N2939ARwrb LLC · Conway, ARBuilt 1969 · S/N CE-286 N2939DHarold Robert E · Fairbanks, AKBuilt 1955 · S/N 26882 N2939FGeorges Aerial Spraying Service Inc · Sutton, NEBuilt 1966 · S/N 18257039 N2939JCaballeros Aircraft LLC · Snohomish, WABuilt 1979 · S/N 28-7990576 N2939LDonahue Paul · West Palm Beach, FLS/N 670073 N2939NPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 28R-7931263 N2939Q7777 Aviation LLC · Bartow, FLS/N 28-7790425 N2939US & S Aviation Co · Ball Ground, GAS/N 17250539 N2939YDanzy Michael R · Oakdale, LABuilt 1962 · S/N 18253939 N293CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266259 N293FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844176 N293HPThree View Flyers LLC · Hauppauge, NYBuilt 2004 · S/N 2843603 N293LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020015 N293MGGeorgia Aviation Authority · Eastman, GABuilt 2015 · S/N 2844155 N293NDChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496028 N293RLCunningham Clinton · Kissimmee, FLBuilt 1975 · S/N 28-7505126 N293SMKemp Aviation LLC · Hiram, GABuilt 1982 · S/N EA-329 N293WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020054 N29407Guymon Stephen L · Mesa, AZS/N 28-7921034 N29408Angels Aviation LLC · Ripon, CABuilt 1979 · S/N 28-7921035 N2940ABarnett David E Trustee · Anchorage, AKBuilt 1953 · S/N 30140

Back to AD 98-21-21 R1