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.

N363JHBering Air Inc · Nome, AKBuilt 2002 · S/N BB-1799 N364WBWayne Ross Biddell · Oklahoma City, OKBuilt 2022 · S/N 4698208 N365BTJaars Inc · Waxhaw, NCBuilt 1971 · S/N 729 N367ACAcc Integrated Services Inc · Milwaukee, WIBuilt 1983 · S/N SH3626 N368ACAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3651 N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291 N36TGRv Holding LLC · Winchester, MABuilt 1996 · S/N LJ-971 N370UBoard Of Regents Of The University Of Oklahoma · Norman, OKS/N LJ-1428 N373HDHinkle Air Spray Inc · Cavalier, NDBuilt 2001 · S/N 502B-0636 N375BCYellowstone Leasing LLC · Pray, MTBuilt 1991 · S/N FL-56 N375RDDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 4697003 N377LAFickes Aerial & Ag Services LLC · Norfolk, NEBuilt 1996 · S/N 502B-0377 N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378 N378HHGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N 378 N379BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20800414 N37HDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-48 N37TDTwin Disc Inc · Racine, WIBuilt 1990 · S/N FL-25 N381MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3703 N382MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3704 N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747 N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615 N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383 N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158 N385MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3707 N386AFBank Of Utah Trustee · Portsmouth, NHBuilt 2024 · S/N 2386 N386ARRustic Corp · Fort Worth, TXBuilt 1999 · S/N 208B0787 N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775 N387SCHeritage Aviation Management Ltd · Conroe, TXBuilt 1999 · S/N FM-10 N388TWTl Lobo Group LLC · Rockwall, TXBuilt 2000 · S/N 4697018 N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439 N38VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-105 N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313 N390PSMcm Holdings Inc · Lincoln, NES/N LW-279 N391ACAmerican Champion Aircraft Corp · Rochester, WIBuilt 1979 · S/N 400-98 N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165 N394LAAerial Solutions Of Tennessee LLC · Milan, TNBuilt 1994 · S/N 502B-0242 N394SFCity Wings Inc · St Thomas, VIBuilt 2005 · S/N 20800394 N395AAAdvanced Air LLC · Hawthorne, CABuilt 1991 · S/N FL39 N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575 N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021 N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421 N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012 N398AStr Holdings LLC · Lafayette, INBuilt 1994 · S/N 208B0390 N398RKAir Worthy Inc · Lyon, MSBuilt 1998 · S/N 602-0484 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N399TWArx Air LLC · Windermere, FLBuilt 1983 · S/N LA-203 N399WSGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1547 N39GKBusiness & Pleasure Air Charter LLC · Bakersfield, CABuilt 2000 · S/N 1039 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N3BAConstruction Enterprises Inc · Franklin, TNBuilt 1997 · S/N FL-181

Back to AD 2014-17-08 R1