Registered aircraft · 1,110

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

N202LGLegacy 20 Enterprises LLC · Wilmington, DEBuilt 2000 · S/N 258454 N202WRDumont Associates Inc · Morris Plains, NJBuilt 1987 · S/N 24 N2033Aircraft Holding Solutions LLC Trustee · Newark, DES/N 258093 N204BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1990 · S/N 650-0189 N204RTCalifornia Motorsports Group Inc · San Diego, CABuilt 2000 · S/N 204 N209CQFalcon 900ex Msn 98 LLC · New Castle, DEBuilt 2001 · S/N 98 N20CRWestern Air International Corp · Fort Lauderdale, FLBuilt 1983 · S/N 097 N20GJGlobal Jetcare Inc · Brooksville, FLS/N 026 N20GPN83 Charlie Inc · Fort Wayne, INBuilt 1992 · S/N 113 N20GXWide Open Skies Viii LLC · Belgrade, MTBuilt 1981 · S/N 131914 N20PJAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 258275 N211ECEast Coast Flight Services Inc · Easton, MDBuilt 1980 · S/N 166 N211GSInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 021 N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093 N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073 N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332 N217MJMtk Leasing LLC · Woodburn, ORBuilt 2002 · S/N 217 N217PTVapor Air LLC · Camden, DEBuilt 1986 · S/N 163 N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426 N218RXAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1996 · S/N 258323 N21HMIheartmedia Management Services Inc · New York, NYBuilt 1988 · S/N 41 N21HRJetsteam Aviation Inc · Cheyenne, WYRegistration ineffective or invalidBuilt 1981 · S/N 335 N220CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 120 N220PFExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 258542 N222MULanier Air East Coast LLC · Pineville, NCBuilt 1980 · S/N 164 N222NEHigher Cause LLC · Grand Rapids, MIBuilt 2000 · S/N 110 N222PBBlanchard Aviation LLC · Albuquerque, NMBuilt 1999 · S/N 258443 N224JL205 Flintstones LLC · Flint, MIBuilt 1995 · S/N 258279 N227GJAsi Holdings Inc · New Castle, DEBuilt 1987 · S/N 182 N229DN229d LLC · Stuart, FLBuilt 1985 · S/N 427 N229LJN229lj LLC · Bentonville, ARBuilt 2001 · S/N 229 N22CPRegistered aircraftBuilt 2003 · S/N 258624 N232CEN232ce LLC · Newberry, FLBuilt 1984 · S/N 650-0067 N232TAAviation Trading Partners LLC · Shawnee, KSS/N 650-0128 N233KCMp Air LLC · Eagle Point, ORBuilt 1998 · S/N 48 N235LJMango Aviation Parts LLC · Plantation, FLS/N 297 N238AXFabio Lopez · Denver, NCS/N 030 N238DBLewis University · Romeoville, ILBuilt 1977 · S/N 215 N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39 N240CKKalitta Charters LLC · Ypsilanti, MIBuilt 1966 · S/N 24 N240VN240v LLC · Wilmington, DEBuilt 1999 · S/N 258417 N2411APuerto Rico Air Management Services Inc · Coral Gables, FLS/N 650-0103 N241CTAvalair Aircraft Management LLC · Brookshire, TXBuilt 1981 · S/N 355 N241LJDouble Whiskey Aviation LLC · Midland, TXS/N 241 N243JRDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 565 N244CKKalitta Air LLC · Ypsilanti, MIBuilt 1977 · S/N 369 N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066 N244LJN244lj Aviation Inc · Middletown, DEBuilt 1979 · S/N 244 N244RG369ba LLC · West Columbia, SCBuilt 1977 · S/N 154 N248BPNorth Valley Air Ltd · St Thomas, VIBuilt 1998 · S/N 283

Back to AD 96-18-13