Registered aircraft · 1,915

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:87-22-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:87-22-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:87-22-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:87-22-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:87-22-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:87-22-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.

N249AXTailwind Investments LLC · Anchorage, AKBuilt 1991 · S/N UC-160 N249CPAngels Envy Aviation LLC · Denison, TXBuilt 1979 · S/N LJ-841 N249WM249 Aviation LLC · Richland, MSBuilt 1975 · S/N LW-139 N24AWalker John D · Neosho, MOBuilt 1976 · S/N LW-210 N24BGVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N BB-1045 N24EMAsphalt Aviation LLC · Conway, SCBuilt 1976 · S/N BE-6 N24GNGlobal Air Concepts LLC · Anchorage, AKBuilt 1981 · S/N BB-953 N24JDVac Sys Holdings LLC · Roseville, CABuilt 1981 · S/N LA-134 N250FCKorban Aviation LLC · Mcallen, TXBuilt 1985 · S/N BB1215 N250TTLakeside Metal Specialties Inc · Paragould, ARS/N BB1505 N250WGChartco LLC · Salisbury, NCBuilt 2001 · S/N BB-1780 N251CFN251cf LLC · Dove Canyon, CABuilt 1983 · S/N BB-1147 N252RCPrestige Worldwide Flights Two LLC · Imperial, CABuilt 1987 · S/N LJ-1152 N253SFAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC53 N254PCAtlantic Wings LLC · New Bern, NCBuilt 1988 · S/N FA-160 N255TTTrident Aircraft Holdings LLC · Nashville, TNBuilt 2002 · S/N BB-1798 N259SCCei Inc · Wilmington, DES/N LW17 N25GRBarrosa LLC · Scottsbluff, NEBuilt 1996 · S/N LJ-1440 N25WCMau Leasing LLC · Newark, DEBuilt 1998 · S/N BB-1640 N261GBSafford Aviation Service Inc · Coolidge, AZBuilt 1985 · S/N LJ-1119 N261MAMajestic Aviation LLC · Decatur, ALS/N LA-61 N262SPAluminum Eagle LLC · South Jordan, UTBuilt 1984 · S/N FA-33 N263CNorpoth Robert L · Circleville, OHS/N LB28 N264PARisk Assumption LLC · Horseshoe Bay, TXBuilt 1980 · S/N BE-86 N264TSFoxtrot Aviation Services LLC · Canton, OHBuilt 1977 · S/N BE-24 N266RDGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1633 N267COldham Matthew Stephen · Lewisville, TXBuilt 1980 · S/N LJ-896 N268CACaruthers LLC · Moundville, ALBuilt 1978 · S/N LJ-759 N26ARDale Aviation · Rapid City, SDBuilt 2004 · S/N LJ-1725 N26EDynamic Avlease Inc · Bridgewater, VAS/N LW-62 N26PYColibri26 Inc Trustee · Wilmington, DEBuilt 1981 · S/N LA-141 N26RERrr Aviation LLC · Gulfport, MSBuilt 1975 · S/N LJ-676 N26RZUas Transervices Inc · Boca Raton, FLBuilt 1990 · S/N UC-134 N2700R-Plane Inc · Wilmington, DEBuilt 1979 · S/N 465-7 N270ACAlaska Central Express Inc · Anchorage, AKBuilt 1991 · S/N UC-174 N270MNardi Greg P · Missoula, MTBuilt 1967 · S/N LJ-288 N274KARgv Sky LLC · Harlingen, TXBuilt 1978 · S/N LW-274 N275LARts Ventures LLC · San Antonio, TXBuilt 1992 · S/N LJ1275 N277GERltwf LLC · Fiddletown, CABuilt 1990 · S/N BB-1389 N277GLDiamondback Equipment Leasing LLC · Avondale, AZBuilt 1991 · S/N BB-1406 N277JJHjjv LLC · Walterboro, SCBuilt 1982 · S/N BB-1043 N277SPAll Systems Satellite Distributors Of Delaware LLC · Newark, DEBuilt 1980 · S/N LA-77 N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011 N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268 N27RCCoastal Holding LLC · Holland, MIBuilt 1983 · S/N BB-1134 N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740 N282AMRfp Enterprises Inc · Bridge City, TXBuilt 1997 · S/N BB-1571 N282DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N LW-209 N284MRDale Aviation Inc · Rapid City, SDBuilt 2005 · S/N LJ-1729 N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734

Back to AD 87-22-01 R1