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.

N636TAToth Financial Advisory Corp · Leesburg, VABuilt 2002 · S/N BB-1792 N637WMOhmestede Industrial Services Inc · League City, TXS/N BB-1768 N63LBBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N BB-1894 N641TSLifewings II LLC · Harrisonville, MOS/N BB641 N6451DEastern Stearman Inc Trustee · Leesburg, VABuilt 1982 · S/N BB-1009 N646DRWilderness Aircraft Co LLC · Bloomington, MNBuilt 1980 · S/N BB-646 N648DDDashdale Aviation LLC · Fort Dodge, IABuilt 1999 · S/N BB-1683 N649JCDeja Air LLC · Morristown, TNBuilt 1980 · S/N BB-649 N651TM305 Sky LLC · Boca Raton, FLBuilt 1981 · S/N BB-804 N6531NBering Marine Corp · Seattle, WABuilt 1982 · S/N BB-1081 N653DPBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N FA-193 N653TBCallaway Air LLC · Fulton, MOBuilt 1979 · S/N BB586 N654BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-54 N654FMN654fm LLC · Kalispell, MTBuilt 1980 · S/N BB-654 N655SPNational Aviation Company LLC · Goodlettsville, TNS/N BB-1023 N65RTProfessional Travel Inc · La Porte, INBuilt 1975 · S/N BB-97 N65TWRound Hound Holdings LLC · Lewes, DES/N BB-902 N66Federal Aviation Administration · Oklahoma City, OKBuilt 1987 · S/N FF-1 N6604LShoals Aircraft Leasing And Operations LLC · Florence, ALS/N BB-1121 N661BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-61 N662BADepartment Of The Air Force · Hill Afb, UTBuilt 1982 · S/N BL-62 N6644JOcean Aircraft Ltd · Virginia Beach, VABuilt 1982 · S/N BB-1031 N667CCAeromont LLC · Billings, MTBuilt 2003 · S/N BB-1827 N6683WWest Dakota Flight Co LLC · Miles City, MTS/N BB-1154 N66TGAeroconnection King Air LLC · Miami, FLBuilt 1988 · S/N FA-155 N67Federal Aviation Administration · Oklahoma City, OKBuilt 1987 · S/N FF-2 N670RAA5 Aviation LLC · Mcallen, TXS/N FA226 N6728HGuardian Flight LLC · Lewisville, TXBuilt 1984 · S/N BB-1193 N675RNLakeside Aviation LLC · Redwood City, CABuilt 1999 · S/N BB-1676 N676WTHat L Management Inc · Midland, TXBuilt 1981 · S/N BB-872 N678MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N BB-908 N678SSRca Aviation 1 LLC · Tempe, AZS/N BB-1021 N68Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-3 N680CAMetrea Special Aerospace Isr Inc · Oklahoma City, OKBuilt 1999 · S/N BB-1681 N6812WSanborn Map Company Inc · Colorado Springs, COBuilt 1985 · S/N FA-38 N682DRN682dr LLC · Clovis, NMBuilt 1976 · S/N BB-130 N686CFAt Aero LLC · Wilmington, DEBuilt 1982 · S/N BB-1085 N68MNGuardian Flight LLC · Lewisville, TXBuilt 2006 · S/N BB-1962 N69Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-4 N690SCN690sc One LLC · Dover, DEBuilt 1983 · S/N BB-1139 N694KMCarling Technologies Inc · Plainville, CTS/N BB-1922 N697PStaker & Parson Co · Ogden, UTBuilt 1985 · S/N BB1217 N699BWBeech Transport LLC · Tarboro, NCBuilt 1999 · S/N BB-1658 N699TPDoodle Aviation LLC · Burlington, NCBuilt 1985 · S/N FA-73 N70Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-5 N700LXLimpia Logistics LLC · Midland, TXBuilt 1999 · S/N BB-1657 N700NAAtlanta Air Charter Inc · Kennesaw, GABuilt 1994 · S/N BB-1491 N700ZAti Aviation LLC · Johnstown, PAS/N BB-1920 N701AXHeli Ranch LLC · Auburn, WABuilt 1987 · S/N FA-116 N702MAZion Asset Management LLC · Saint Clair Shores, MIS/N BB-1010

Back to AD 89-19-04 R1