Registered aircraft · 2,525

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.

N322HGH & O Aviation LLC · Oxford, MSBuilt 1993 · S/N FL-93 N322MRPf Aircraft LLC · Graham, TXBuilt 2000 · S/N LJ-1611 N322MTSkyak LLC · Chanhassen, MNBuilt 2022 · S/N 4698237 N322WWWest Aviation LLC · Palm City, FLBuilt 2020 · S/N 4698133 N324WRenshi LLC · Palm City, FLBuilt 2024 · S/N K059 N3250VK & J Air Services Ltd · Midland, TXBuilt 1995 · S/N BB-1523 N3252YPa1 208b-1088 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1088 N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144 N325PWWatson 321 Air LLC · Flower Mound, TXBuilt 2023 · S/N 4698273 N3262REaglemed LLC · Wichita, KSBuilt 1999 · S/N LJ-1562 N3263CEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1432 N3263NGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1563 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360 N327BGGrimsley Aviation LLC · Dallas, TXBuilt 2001 · S/N 4697073 N327MJTour Aviation LLC · Naples, FLBuilt 2005 · S/N 1099 N327MZWdl/Oracle LLC · Tucson, AZBuilt 1998 · S/N 4636160 N327RHealth Care Capital Of North Carolina LLC · Atlanta, GABuilt 1999 · S/N FL-259 N327SFState Of Colorado · Lakewood, COBuilt 2003 · S/N 511 N327WLSouth Aero Inc · Albuquerque, NMBuilt 1996 · S/N 208B0547 N32973Crop Jet Aviation LLC · Gooding, IDBuilt 1995 · S/N T45-009 N3299KJones Aviation Inc · Biggs, CABuilt 1996 · S/N T45-012 N3299PAir Care Leasing LLC · Lamar, COBuilt 1996 · S/N T42-213 N329ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-329 N329GSAugusta Aviation Inc · Hilton Head Island, SCBuilt 1992 · S/N LJ-1320 N329MMRuegg Aircraft Holdings LLC · Wilmington, NCBuilt 2001 · S/N 192 N32CARegistration Pending · Fairbury, NERegistration pendingBuilt 2005 · S/N 4697216 N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230 N330DBBlueskyways LLC · Bend, ORBuilt 1999 · S/N LJ-1542 N331JPSfh Inc DBA · Fargo, NDBuilt 2005 · S/N LJ-1756 N331KECrop Air LLC · Eaton, COBuilt 1982 · S/N 400A-0460 N331RFRandigo LLC · Wilmington, DEBuilt 1999 · S/N 208B0754 N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087 N332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1982 · S/N LJ1023 N333MLSeneca Flight Group LLC · Clearwater, FLBuilt 2023 · S/N K039 N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702 N333XPRichard L Richards Pa Trustee · Coral Gables, FLBuilt 2000 · S/N LJ-1609 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N3356YAdvanced Aviation Services LLC · Sheridan, WYBuilt 1992 · S/N FM-4 N336KTBlue Sky Worldwide LLC · Wilmington, DEBuilt 2001 · S/N 4697033 N336RKBridger Aerospace Group Holdings LLC · Belgrade, MTBuilt 1992 · S/N FL-71 N339KAChenango Aviation LLC · Dallas, TXBuilt 1980 · S/N LW-339 N33FGFlightline Group Inc · Tallahassee, FLBuilt 2026 · S/N 46020114 N33HGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2022 · S/N 4698200 N33KCCarvair LLC · Salem, ORBuilt 1984 · S/N FA-35 N33MCTwin Rivers Aircraft LLC · Sebastopol, CABuilt 2001 · S/N 1051 N3407GRedditt Air Service Inc · Cleveland, MSBuilt 1978 · S/N 43C N342FAJb Aircraft LLC · Anchorage, AKBuilt 2010 · S/N 208B2162 N342THHill Thomas D · Parma, IDBuilt 1981 · S/N GM-87 N343RRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 4697197

Back to AD 2014-17-08 R1