Registered aircraft · 897

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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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:89-19-04-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.

N361EAAlcyone Trust Corp Trustee · Wichita, KSS/N BB-1103 N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741 N361TDSequoia Beverage Co Lp DBA · Visalia, CABuilt 1986 · S/N BL-128 N3620MSanford Medical Center · Sioux Falls, SDBuilt 1991 · S/N BB-1396 N363DFreeman Holdings Of West Texas LLC · Medford, ORBuilt 1995 · S/N BB-1503 N363JHBering Air Inc · Nome, AKBuilt 2002 · S/N BB-1799 N365CSN365cs LLC · Mcallen, TXS/N FA-120 N36987Westflight LLC · Yuma, AZBuilt 2004 · S/N BB-1887 N370CSReach Air Medical Services LLC · Santa Rosa, CABuilt 1996 · S/N BB-1550 N372JBUltra Property Acquisitions LLC · Edinburg, TXBuilt 1980 · S/N BB-719 N375JPAir T-Jam LLC · Uniontown, PABuilt 2003 · S/N BB1833 N377JEAcr Advertising LLC · Jasper, INS/N BB-1843 N378SFTrigg David D · Houston, TXBuilt 1978 · S/N BB-378 N379EKAvtrust LLC Trustee · Wilmington, DEBuilt 2001 · S/N BB-1769 N380JPPaalmc Llv · Shreveport, LAS/N BB-1889 N381HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1952 N381RUc Aviation Holdings LLC · Union City, TNBuilt 1978 · S/N BB-385 N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615 N389RAAirtrex Aircraft Xray Inc · Wichita, KSBuilt 1986 · S/N BL-56 N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439 N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313 N390SPState Of Arkansas · Little Rock, ARS/N BB-1970 N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165 N392CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 398 N393JWGeneration Jets LLC · Denison, TXBuilt 1977 · S/N BB-292 N395AMHollan Air LLC · Amarillo, TXS/N BB-1101 N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421 N399ALBallard Aviation Inc · Newton, KSS/N BB-1623 N3AHEat Veggies 3 LLC · Savannah, GABuilt 1987 · S/N FA-130 N3HBSunset Aviation LLC · Port Angeles, WABuilt 1979 · S/N BB-453 N3MHN3mh LLC · Kalispell, MTBuilt 1985 · S/N BB-1228 N3NCNorth Carolina Dept Transportation · Raleigh, NCBuilt 2007 · S/N BB-1976 N3PXAirtime LLC · Mont Belvieu, TXBuilt 1984 · S/N BB-1173 N400DAFive Saguaro Leasing LLC · Albuquerque, NMBuilt 1984 · S/N FA-11 N400GWGpw LLC · Laurel Springs, NCBuilt 1997 · S/N BB-1583 N400SCN400sc LLC · Walterboro, SCBuilt 1982 · S/N BB-1040 N400SLTurbo Air Charter LLC · Boise, IDBuilt 1980 · S/N BB-697 N401NSNs 300 LLC · Atlanta, GABuilt 1985 · S/N FA-28 N402RX56 Express LLC · Willmar, MNBuilt 1988 · S/N FA-163 N4047CInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N BB202 N404DPValie Air LLC · Statesboro, GABuilt 1981 · S/N BB-819 N4053HCosmos Holdings Group LLC · Newark, DEBuilt 2001 · S/N BB-1774 N405PTDodson International Parts Inc · Rantoul, KSS/N BB-930 N409RATurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N BB-429 N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7 N410RTStewart Aviation Services LLC · Birmingham, ALBuilt 2007 · S/N BB-1978 N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520 N411KCPonderosa Aviation LLC · Safford, AZBuilt 1981 · S/N BB-901 N411MHObair 26 LLC · Memphis, TNBuilt 1979 · S/N BB-566 N411WAGuardian Flight LLC · Lewisville, TXBuilt 1988 · S/N BB-1294

Back to AD 89-19-04 R1