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.

N520DGDanzer Veneer Americas Inc · Darlington, PABuilt 2001 · S/N BB-1753 N520MCBedrock LLC · Anniston, ALBuilt 1975 · S/N BB-43 N521FTR & G Aviation LLC · Hazlehurst, GABuilt 1980 · S/N BL-012 N522TGSe Express LLC · South Lyon, MIBuilt 1985 · S/N BB-1209 N524GMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N BL-142 N524MRMt King Air · Stevensville, MTBuilt 1979 · S/N BB524 N525SKCb4 LLC · Wilmington, DEBuilt 1983 · S/N BB-1148 N527CHSafeco Leasing LLC · Port Alsworth, AKBuilt 1981 · S/N BB-899 N529NANasa Langley Research Center · Hampton, VAS/N BB-1091 N52CSpritzair LLC · North Palm Beach, FLBuilt 1981 · S/N BB-992 N52LDynamic Avlease Inc · Bridgewater, VAS/N BT-31 N530LMCorsair Two LLC · Hillsboro, ORBuilt 1999 · S/N BB1678 N531AWCsi 135 Division LLC · Albuquerque, NMBuilt 1986 · S/N FA-98 N531LMCorsair Two LLC · Hillsboro, ORFirst renewal noticeS/N BB1852 N532AWCsi Aviation Inc · Killeen, TXBuilt 1991 · S/N FA-218 N532LMCorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N BB-1996 N534AWCsi Aviation Inc · Killeen, TXBuilt 1988 · S/N FA154 N535PNDavis Aviation Inc DBA · Brandon, MSS/N FA-152 N53ARGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N BB-1629 N53BAIvester Drywall & Painting Inc · Salisbury, NCBuilt 1979 · S/N BB-426 N53GA52 Whiskey LLC · Elkhart, INBuilt 1985 · S/N BB-1201 N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880 N53WDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BL-53 N540MAN540ma LLC · Metairie, LABuilt 2001 · S/N BB-1765 N541JGLogistics Alaska LLC · Anchorage, AKBuilt 1981 · S/N BB-989 N541LMCorsair Two LLC · Hillsboro, ORBuilt 2005 · S/N BB-1899 N541SCKing Air N541sc LLC · Fresno, CABuilt 1987 · S/N FA-138 N545LMAero Air LLC · Hillsboro, ORBuilt 1982 · S/N BB-1069 N546LMAero Air LLC · Hillsboro, ORBuilt 1985 · S/N BB1235 N54CHLawsuit Air LLC · Onalaska, TXBuilt 1989 · S/N FA-188 N54FDynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BL-46 N54TKDlp Real Estate Capital Inc · Saint Augustine, FLBuilt 1980 · S/N BB-686 N550GLGaba Zero Seven LLC · Beaumont, TXBuilt 1980 · S/N BB-781 N550SPBh Sabbah LLC · Visalia, CABuilt 1997 · S/N BB-1572 N551JLN551jl LLC · Greenville, SCBuilt 1980 · S/N BB-788 N555FWCommerce Flight LLC · Commerce, TXBuilt 1982 · S/N BB-1055 N555WERfs Equipment LLC · Newport Beach, CAS/N BB-1490 N556ALEaglemed LLC · Wichita, KSBuilt 1999 · S/N BB-1670 N55ADynamic Avlease Inc · Bridgewater, VABuilt 1982 · S/N BL-55 N55PCCteh Leasing LLC · N Little Rock, ARBuilt 1983 · S/N BB-1170 N55SRGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N BB-445 N561KGGehrair LLC · Palm Beach Gardens, FLBuilt 1991 · S/N FA-212 N561SSEnvision Ventures LLC · Williston, NDBuilt 1979 · S/N BB-464 N561ZAZulu Air LLC · Opa Locka, FLS/N BB1180 N566KADalks Leasing Inc · Wilmington, DEBuilt 1989 · S/N FA-201 N568TTAshland Aviation LLC · Ashland, OHBuilt 1997 · S/N BB1568 N56ACentral Virginia Aviation Inc · Petersburg, VABuilt 1981 · S/N BL-37 N56CDDewahl Adventures LLC · Bigfork, MTBuilt 1975 · S/N BB-64 N56GMMarianna Logistics LLC · Moro, ARBuilt 2011 · S/N BB-2017 N571TMBranhill Plantation Reserve LLC · Wilmington, DEBuilt 1979 · S/N BB-571

Back to AD 89-19-04 R1