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.

N24GNGlobal Air Concepts LLC · Anchorage, AKBuilt 1981 · S/N BB-953 N250FCKorban Aviation LLC · Mcallen, TXBuilt 1985 · S/N BB1215 N250TMAbd Equipment LLC · Aledo, TXS/N BB822 N250TTLakeside Metal Specialties Inc · Paragould, ARS/N BB1505 N250WGChartco LLC · Salisbury, NCBuilt 2001 · S/N BB-1780 N251CFN251cf LLC · Dove Canyon, CABuilt 1983 · S/N BB-1147 N254PCAtlantic Wings LLC · New Bern, NCBuilt 1988 · S/N FA-160 N255TTTrident Aircraft Holdings LLC · Nashville, TNBuilt 2002 · S/N BB-1798 N259GCotton Tail Transportation LLC · Singer Island, FLBuilt 1975 · S/N BB-62 N25WCMau Leasing LLC · Newark, DEBuilt 1998 · S/N BB-1640 N262SPAluminum Eagle LLC · South Jordan, UTBuilt 1984 · S/N FA-33 N269LSSky King LLC · West Fargo, NDBuilt 1981 · S/N BB-799 N269MLAtlantic Wings LLC · New Bern, NCBuilt 1980 · S/N BB-760 N277GERltwf LLC · Fiddletown, CABuilt 1990 · S/N BB-1389 N277GLDiamondback Equipment Leasing LLC · Avondale, AZBuilt 1991 · S/N BB-1406 N277JJHjjv LLC · Walterboro, SCBuilt 1982 · S/N BB-1043 N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268 N27RCCoastal Holding LLC · Holland, MIBuilt 1983 · S/N BB-1134 N280RATechnology Service Corp · Arlington, VABuilt 1975 · S/N BB-53 N280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXBuilt 2000 · S/N BB-1740 N282AMRfp Enterprises Inc · Bridge City, TXBuilt 1997 · S/N BB-1571 N282LSJh Strain & Sons Inc · Tye, TXBuilt 1975 · S/N BB82 N284KMidsouth Air LLC · Lewes, DEBuilt 1979 · S/N BB-608 N288ATN38ry LLC · California, MDBuilt 1987 · S/N FA134 N288KMGarmin International Inc · Olathe, KSBuilt 1995 · S/N BB-1508 N28ELDodson International Parts Inc · Rantoul, KSS/N FA-144 N28KMN28km LLC · Wilmington, NCBuilt 1983 · S/N BB-1159 N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540 N28VUPhysicians Air Transport LLC · Hot Springs, ARBuilt 1980 · S/N BB-743 N291PANorthrop Grumman Systems Corp · El Segundo, CABuilt 1977 · S/N BB-291 N295DCHibiscus26 Inc Trustee · Wilmington, DEBuilt 2000 · S/N BB-1709 N299AVTeton Leasing LLC · Pocatello, IDBuilt 1999 · S/N BB-1680 N299MKBoman & Kemp Manufacturing Inc · Ogden, UTBuilt 1990 · S/N BB1357 N299RBKing Air Partners LLC · Howe, OKBuilt 1977 · S/N BB-296 N29PENv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2005 · S/N BB-1913 N29VKV-Jet Aircraft Holding Co Trustee · Dover, DEBuilt 2001 · S/N BB-1776 N29VRV-Jet Aircraft Holding Co Trustee · Dover, DEBuilt 1993 · S/N BL139 N2DBKa300 LLC · Greenwood Village, COBuilt 1985 · S/N FA-37 N2GGN2gg Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1539 N300AJAsm Aviation LLC · Bismarck, NDBuilt 1981 · S/N BB-965 N300CWDome Aviation LLC · Loomis, CAS/N FA-115 N300KLPeddinghaus Corp · Bradley, ILBuilt 1985 · S/N FA39 N300MCHighway 16 Ranch LLC · Corpus Christi, TXBuilt 1986 · S/N FA-91 N300PTGjf Enterprises Inc · Port Orange, FLBuilt 1984 · S/N FA-34 N300SEJetx Air LLC · Camden, DEBuilt 1985 · S/N FA-68 N300TEKingair 61 LLC · Wilmington, DEBuilt 1984 · S/N FA-19 N300TNWild Blue Aviation LLC · Wilmington, DEBuilt 1988 · S/N FA-168 N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319 N300WMWalker Manufacturing Co · Fort Collins, COBuilt 1988 · S/N FA156 N300WQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1984 · S/N FA-8

Back to AD 89-19-04 R1