Registered aircraft · 3,462

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:2002-23-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:2002-23-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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.

N827KBArkansas Air Partners LLC · Jonesboro, ARBuilt 1978 · S/N LW-287 N827LALepanto Crop Service Inc · Lepanto, ARBuilt 2012 · S/N 502B-2827 N828FCGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1436 N828MSPence Dale E · Garnett, KSBuilt 1999 · S/N 502B-0576 N828NCBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N LJ-2064 N828PGPowell 737pg LLC · Baton Rouge, LABuilt 1999 · S/N FL-232 N828SSSusanaire LLC · Dallas, TXBuilt 1986 · S/N BB-1252 N828TJKct Holdings LLC · Gainesville, FLBuilt 2012 · S/N EVO-0042 N829MCKidd Johnston Aviation LLC · Odessa, TXBuilt 2000 · S/N BB-1708 N829SJInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N EVO-0037 N82AXBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N K121 N82BCGulf Air Aviation Inc · Wilmington, DEBuilt 1989 · S/N LJ1222 N82CXEpic Aircraft LLC · Bend, ORBuilt 2020 · S/N K004 N82HKKootenai Business Properties LLC · Post Falls, IDS/N 100-0082 N82LHAirborne Support Group LLC · Marion, MTBuilt 1969 · S/N 208 N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034 N82XPJones Harry R Jr · Houston, TXBuilt 1982 · S/N LJ-1012 N83110Jones Aviation Inc · Biggs, CAS/N 11D N831FEFederal Express Corporation · Memphis, TNS/N 208B0225 N831VFEpic Aircraft LLC · Bend, ORBuilt 2021 · S/N K014 N8347KPorter Flying Service LLC · Missoula, MTBuilt 1980 · S/N 22D N836PDMid Atlantic Air Museum · Reading, PABuilt 2006 · S/N F-836 N838RAT206 Aviation LLC · Stockton, CAS/N 71 N838SAFargo Aviation Lllc · Fargo, NDBuilt 2007 · S/N 100-0002 N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621 N83GTChambliss Aerobatics LLC · Chandler, AZBuilt 2001 · S/N 46-97032 N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283 N83RWEhr Ventures LLC · Jourdanton, TXBuilt 1991 · S/N LJ-1271 N83WEMiner'S Inc · Hermantown, MNBuilt 1978 · S/N LW-289 N840CAMetrea Special Aerospace Isr Inc · Bethany, OKS/N FL-104 N840JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1985 · S/N 20800056 N841FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 208B0144 N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841 N842EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE-336 N842EBIsr Aviation LLC · Wilmington, DEBuilt 1989 · S/N 208B0146 N843BHGaylord Theodore Scott DBA · La Grange, CABuilt 2001 · S/N 196 N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090 N843EElectric Boat Corp · Groton, CTBuilt 1998 · S/N UE339 N843FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0147 N844FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0149 N845FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0152 N846BEM D Airways Inc · Derby, KSBuilt 1984 · S/N FA-16 N846DJHeritage Aviation Management Ltd · Conroe, TXBuilt 1992 · S/N FM-7 N846FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0154 N846RDRegistration Pending · Naples, FLRegistration pendingBuilt 2004 · S/N 4697186 N847BABeech Transportation Inc · Eden Prairie, MNBuilt 1981 · S/N BB847 N847CPFedair LLC · Indianapolis, INBuilt 2001 · S/N 4697080 N847FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0156 N848FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0158 N8499KHatfield'S Spraying Service Inc · Nunica, MIBuilt 1982 · S/N 720B

Back to AD 2002-23-13