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.

N135MKRio Frio Leasing Co LLC · Houston, TXBuilt 1984 · S/N FA-3 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23 N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286 N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276 N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50 N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N155AVTeton Leasing LLC · Pocatello, IDBuilt 1985 · S/N BB-1216 N155BBRegistration Pending · Greer, SCRegistration pendingBuilt 1997 · S/N BB-1554 N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N162GCUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N BB-1238 N162QMartin Foundry Service Inc · Glencoe, ALBuilt 1982 · S/N BB-1104 N163BALbk Air LLC · Newark, DEBuilt 1984 · S/N FA-18 N1655MMichigan Aeronautics Commission · Lansing, MIBuilt 1999 · S/N BB-1655 N166BASmith Joshua B · Kenai, AKBuilt 1988 · S/N FA-147 N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166 N169RWJorgensen Air Service LLC · Puyallup, WABuilt 1982 · S/N BB-1030 N16CMBartholow Rental Co Inc · Wylie, TXBuilt 1997 · S/N BB-1580 N16HGBear Air LLC · Mount Vernon, INBuilt 1999 · S/N BB-1647 N170JCWlgb200 LLC · Reno, NVBuilt 1998 · S/N BB-1606 N170RLN170rl LLC · California, MDBuilt 1983 · S/N BT28 N173KSCentralav LLC · Lake Worth, FLS/N FA-82 N173TX173 Tango X-Ray LLC · Houston, TXBuilt 1982 · S/N BB-1028 N174JBAes Aviation LLC · Tuskegee, ALBuilt 1992 · S/N BB-1429 N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183 N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029 N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191 N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203 N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236 N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257 N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670 N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602 N184DNorth Country Holdings LLC · Moses Lake, WABuilt 1987 · S/N FA-132 N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241 N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034 N187MRJcs Air LLC · Auburn, ALS/N BB-873 N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111 N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32 N189APRegistered aircraftBuilt 1975 · S/N BB-59 N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497

Back to AD 89-19-04 R1