Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N78EHN78eh Management LLC · Lewes, DEBuilt 1978 · S/N 32R-7887025 N78FLFlight Levels LLC · Ridgeland, MSBuilt 2005 · S/N 4636371 N78GBJones Richard · Cornville, AZBuilt 1978 · S/N 32R-7887282 N78GHCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 31-7852121 N78GSAir Mods And Repair Corp · Robbinsville, NJBuilt 1972 · S/N 27-4833 N78JT71793 LLC · San Luis Obispo, CABuilt 1978 · S/N 27-7854138 N78KTJbt Aviation LLC · Shawano, WIBuilt 1975 · S/N 61P-0258-049 N78MRShembekar Ajit R · Novi, MIS/N 32R-7987095 N78MSDibenedetto Todd P · Riverwoods, ILS/N 31-7812074 N790BBBeitel Robert R · Lake Wylie, SCBuilt 1968 · S/N 27-4023 N7942CN4143w LLC · Los Gatos, CABuilt 1975 · S/N 32R-7680069 N794RSRegistered aircraftS/N 27-0007 N794SATmb Aviation LLC · Fresno, CABuilt 2001 · S/N T18208062 N7951CJaybec Corp · Pinecrest, FLBuilt 1975 · S/N 32R-7680070 N7952CKramer Kartie K · Mckinney, TXBuilt 1975 · S/N 32R-7680071 N795DHSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609061 N795JBMountain High LLC · Ketchum, IDBuilt 1969 · S/N 24-4894 N795MAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 4636007 N7967VAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 1576 N7968PDavison William A · Hamilton, MTBuilt 1962 · S/N 24-3205 N7970PStevens Jon A · Byron, MNBuilt 1962 · S/N 24-3207 N7975PB&R Aircraft LLC · Wadsworth, OHBuilt 1962 · S/N 24-3212 N7978PKozak Aeronautical Company · Wilmington, DEBuilt 1962 · S/N 24-3215 N797BBKurt Aviation · Middleton, DEBuilt 2002 · S/N T18208148 N797MAJtcc Products LLC · Fairview Park, OHBuilt 1997 · S/N 4636108 N797MCTim 2 Fly LLC · Conroe, TXBuilt 1997 · S/N 4636117 N797SLow Wing 797 LLC · Aurora, ILBuilt 1997 · S/N 3257003 N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439 N7983YMclaughlin Scott A · Defiance, IABuilt 1966 · S/N 30-1085 N7984PMiller Jason Christopher · Woodbury, NJBuilt 1962 · S/N 24-3222 N7988HTc Loox Consultants LLC · Washington, DCBuilt 1984 · S/N 60-8423021 N798BSBurnkey Aviation LLC · Declo, IDS/N 32R-7887020 N7991VNorth Carolina Soaring Association · Zebulon, NCBuilt 1970 · S/N 1586 N7993PMartz Todd B · Pleasant Hill, CABuilt 1962 · S/N 24-3232 N7998VDonica Leldon H · Marana, AZBuilt 1970 · S/N 1589 N799CERed Oar Aviation LLC · Lookout Mountain, TNS/N 1807-17 N799GFNorth Dakota Game And Fish Dept · Bismarck, NDBuilt 2006 · S/N T18208487 N79LDTcb Aviation LLC · Evansville, INBuilt 1982 · S/N 31-8252062 N79LKGonzalez Leon · Pembroke Pines, FLBuilt 1980 · S/N 31-8012092 N79MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1999 · S/N 232 N7ACCommander Quest LLC · San Luis Obispo, CABuilt 1961 · S/N 500B-1013-34 N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964 N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802 N7FMAppalachian Racing Aviation LLC · Johnson City, TNBuilt 1971 · S/N 32-7240041 N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718 N7HXBlairtogaii Inc · Novi, MIBuilt 1982 · S/N 32-8224005 N7JVGreer Air Inc · Saint Cloud, FLBuilt 1971 · S/N 31-789 N7LLBautista Sean P · Reedley, CABuilt 1974 · S/N 310Q1019 N7PQStarr James Trey · Oklahoma City, OKBuilt 1976 · S/N 14096 N7XACine Aviation Inc · W Bloomfield, MIBuilt 1981 · S/N 32R-8229020

Back to AD 91-21-01 R1