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.

N907DBErics Leading Edge Inc · St George, UTBuilt 1985 · S/N FA-85 N907GSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N BB-905 N908MHMeadows Homes Inc · Cookeville, TNBuilt 2001 · S/N BB-1781 N90AMTexas A And M University · College Station, TXBuilt 1989 · S/N BB-1328 N90WFRegistration Pending · Midland, TXRegistration pendingBuilt 1988 · S/N FA-164 N910AJL'Eagle Air II Inc · Newark, DEBuilt 1981 · S/N BB-910 N910KGLg Air LLC · Baton Rouge, LABuilt 1983 · S/N BB1051 N911CMPhi Health LLC · Tempe, AZBuilt 1996 · S/N BB-1551 N911KADavis Aviation DBA · Brandon, MSS/N FA-44 N911RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1992 · S/N BB-1425 N911SFReiner Russell · Redding, CABuilt 1999 · S/N BB-1659 N912MNAvera Mckennan · Sioux Falls, SDBuilt 1993 · S/N BB1468 N912SVSaint Vincents Healthcare · Billings, MTBuilt 1988 · S/N BB-1299 N913RXReach Air Medical Services LLC · Santa Rosa, CABuilt 1993 · S/N BB-1471 N914JALake Area Technical College · Watertown, SDBuilt 1989 · S/N FA-191 N914SHSanford Medical Center · Sioux Falls, SDBuilt 1999 · S/N BB-1688 N917WAN917wa Corp Trustee · Wilmington, DEBuilt 1985 · S/N FA-77 N918DDDiamond D Aviation LLC · Sulphur, LABuilt 1999 · S/N BB-1677 N919HPKing Three LLC · Forest Hill, MDBuilt 1985 · S/N FA-81 N919REIvy Brothers Aviation LLC · Kilgore, TXS/N BB824 N91MFCkw Aviation LLC · Dalhart, TXBuilt 1980 · S/N BB-657 N91RWJujufa21 LLC · Wilmington, DEBuilt 1984 · S/N FA-21 N921AZArizona Department Of Public Safety · Phoenix, AZBuilt 1988 · S/N BB-1287 N922ALBallard Aviation Inc · Newton, KSS/N BB1529 N923ASDjp Properties LLC · Selma, CABuilt 1979 · S/N BB-541 N924ACDena'Ina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB483 N924JBN924jb LLC · Little Rock, ARBuilt 2004 · S/N BB-1849 N926TJBlackhawk Consulting LLC · Raceland, LABuilt 1999 · S/N BB-1662 N928KAction Offshore LLC · Port Arthur, TXBuilt 1998 · S/N BB-1608 N928KLKa-B200 LLC · San Angelo, TXBuilt 1994 · S/N BB-1482 N929BWSkyway K LLC · Middletown, DEBuilt 1998 · S/N BB-1630 N92WCAviation Group LLC · Wilmington, DEBuilt 1989 · S/N BB-1330 N933RTZito Aviation LLC · La Salle, COS/N BB-955 N935AJDouble C Air LLC · Sacramento, CABuilt 1981 · S/N BB-935 N939BWPoky Feeders Inc · Scott City, KSBuilt 1989 · S/N FA175 N940HCAll Aviation LLC · Hudson, WIBuilt 1988 · S/N BB-1303 N942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNBuilt 2000 · S/N BB-1731 N944CWby Enterprises II LLC · Jackson, TNBuilt 2001 · S/N BB-1749 N944LSJmb Air LLC · Algona, IABuilt 1979 · S/N BB-604 N946CGJk Aviation LLC · Grosse Ile, MIBuilt 1989 · S/N FA-198 N948CEPro-Serve Aviation LLC · Englewood, COBuilt 2000 · S/N BB-1736 N949BWBering Air Inc · Nome, AKS/N BB-1763 N949CFTee Pee Wings LLC · San Angelo, TXS/N BB-1828 N949MAMajestic Aviation LLC · Billings, MTBuilt 2002 · S/N BB-1795 N949REAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1981 · S/N BB-949 N950MBLos Angeles County Sheriffs Department · Long Beach, CABuilt 1990 · S/N BB-1372 N953AJS A Comunale Co Inc · Barberton, OHBuilt 2000 · S/N BB-1723 N954MSBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N BB-1649 N954ZAZulu Air LLC · Opa Locka, FLBuilt 2000 · S/N BB-1712 N957CBBd Air LLC · Battle Ground, WABuilt 1998 · S/N BB-1624

Back to AD 89-19-04 R1