Registered aircraft · 2,524

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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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:2014-17-08-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.

N717JGHvl Air · Fresno, CABuilt 1975 · S/N LJ-672 N717LETentacle Corp · Walnut Creek, CABuilt 1988 · S/N 549 N717PAPa1 208b-0804 LLC · Fort Lauderdale, FLBuilt 2000 · S/N 208B0804 N718FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0448 N7199LDynamic Avlease Inc · Bridgewater, VABuilt 1971 · S/N LU-09 N7199SDynamic Avlease Inc · Bridgewater, VABuilt 1972 · S/N LU-11 N719BHWilliams Farms LLC · Panhandle, TXBuilt 1979 · S/N BB-564 N719FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0450 N719HPWoolpert Inc · Dayton, OHBuilt 2006 · S/N 208B1191 N71SCWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B0997 N7206EEt Aviation LLC · Alcoa, TNS/N LA-234 N720AMKing Eagle II LLC · Grand Blanc, MIBuilt 1999 · S/N BB-1663 N720COscar Charlie LLC · California, MDBuilt 1973 · S/N B-171 N721RDKing Edward Inc · Cullman, ALBuilt 1980 · S/N BB677 N721SRNcs Aviation LLC · Bemidji, MNBuilt 2000 · S/N 181 N72213Skyline Aviation Services LLC · Miramar, FLBuilt 1994 · S/N LJ-1450 N722FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0454 N722VBCopacetic Air LLC · Rutledge, TNS/N LJ987 N7230HAb Aviation LLC · Johns Island, SCBuilt 1985 · S/N LJ-1113 N723FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0456 N723SCRegistered aircraftBuilt 1994 · S/N NC-50 N724AAAlbright Insurance Holdings Inc · Burlington, NCBuilt 1998 · S/N BB-1632 N724DMBusker Aviation LLC · Detroit Lakes, MNBuilt 1999 · S/N 143 N724FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0458 N724KHCloud Nine Corp · Batesville, INBuilt 1995 · S/N LJ-1426 N725LMSimply Living LLC · Fort Myers, FLBuilt 2002 · S/N 20800351 N725RABar Environmental Supply Inc · Brentwood, TNBuilt 1980 · S/N BB-725 N726FXFederal Express Corporation · Memphis, TNS/N 208B0465 N727FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0468 N728EBFifth Pegasus LLC · Dover, DEBuilt 2013 · S/N 20800553 N728FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0471 N729AAAllen Air 2 LLC · Litchfield, MNBuilt 2025 · S/N 46020078 N729CFWells Flying Services LLC · Holdrege, NEBuilt 2000 · S/N 802A-0101 N729FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0474 N729GTBig Sky Aviation LLC · Bozeman, MTBuilt 1996 · S/N FL-143 N72JDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-72 N72KAKenmore Air Harbor LLC · Kenmore, WABuilt 1992 · S/N 208B0326 N72LXSapient Air LLC · Kirkland, AZBuilt 2020 · S/N LIV 213 N72RARoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 110.377 N72RGBushbird LLC · Sioux Falls, SDBuilt 2019 · S/N 20800656 N73Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-8 N73005Mid Atlantic Ag LLC · Nassau, DEBuilt 1985 · S/N 400-0520 N73006Mid Continent Aircraft Corp · Hayti, MOBuilt 1985 · S/N 400A-0501 N7300EMark Gary Flying Service Inc · Inverness, MSBuilt 1984 · S/N 400-0517 N7305GAerial Ag Services LLC · Hillsboro, TXBuilt 1985 · S/N 301-0603 N73070Lake Air Service LLC · Jennings, LABuilt 1999 · S/N 502B-0540 N7307TAas LLC · Ovid, MIBuilt 1985 · S/N 400-0610 N73080Tall Towers Aviation Inc · Page, NDBuilt 1985 · S/N 400-0639 N73084Precision Aerial Ag LLC · Seneca, KSBuilt 1985 · S/N 400-0638 N7308ADevil Dusters Inc · Artesia, NMBuilt 1985 · S/N 400-0624

Back to AD 2014-17-08 R1