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.

N76Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-11 N762PPAway Air LLC · Wilmington, DES/N BB-1897 N764CACarver Aero LLC · Muscatine, IABuilt 1991 · S/N BB-1408 N765WAValiair Lc Trustee · Casper, WYBuilt 1980 · S/N BB-765 N77Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-12 N770ALAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB.77 N770WTS&R Transportation I LLC · Wilmington, NCS/N BB-1925 N771MGEaglemed LLC · Wichita, KSBuilt 1998 · S/N BB-1636 N773CPDbs Aviation LLC · Wilmington, DEBuilt 1986 · S/N BB-1260 N773TPState Of Of Utah · Salt Lake City, UTBuilt 2000 · S/N BB-1722 N77477International Air Services Inc Trustee · Carson City, NVS/N BT-10 N774AKBering Air Inc · Nome, AKS/N BB-1797 N774LKElite Medical Air Transport LLC DBA · Santa Teresa, NMBuilt 2002 · S/N BL-145 N775SCZw Air LLC · Little Rock, ARBuilt 1981 · S/N BB-808 N776RWReliance Well Service Inc · Magnolia, ARBuilt 2006 · S/N BB-1926 N7779VAircraft Fidelity Corp Trustee · Dover, DEBuilt 2001 · S/N BB-1770 N777AQBcms Investments LLC · Dexter, MOBuilt 1979 · S/N BB-583 N777AWFair Air Aviation LLC · Myrtle Beach, SCBuilt 1979 · S/N BB-536 N777KNardi Greg · Titusville, FLBuilt 1982 · S/N BB-1017 N777SSCalderwood Aviation LLC · Shafter, CABuilt 1980 · S/N BB-661 N777TQG And G Operators Ltd · Dalhart, TXBuilt 1989 · S/N BB-1335 N777XPRbwdb Aircraft LLC · Lufkin, TXBuilt 1987 · S/N FA-124 N77CA77ca Associates LLC · Coral Gables, FLBuilt 1980 · S/N BB-717 N77HDArkansas Department Of Transportation · Little Rock, ARBuilt 1991 · S/N BB-1397 N78Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-13 N780CWCasella Major Account Services LLC · Rutland, VTS/N BB-1924 N781HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2004 · S/N BB1854 N782ALAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N BB-1940 N783ALAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N BB-1946 N785WCWillwork 4 Jeta LLC · Houston, TXBuilt 1978 · S/N BB-425 N786DDTransouth Leasing LLC · Longview, TXS/N BB-1171 N789CTKingfisher Associates LLC · Wilmington, DEBuilt 1981 · S/N BB-820 N79Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-14 N791DCExecutive Air Taxi Corporation · Bismarck, NDBuilt 1991 · S/N BB-1402 N791EBSav Aviation LLC · Jacksonville, TXBuilt 1980 · S/N BB791 N793DCBillings Clinic · Billings, MTBuilt 1991 · S/N BB-1404 N795PAPdx LLC · Indianapolis, INS/N BB-328 N797KDDodson International Parts Inc · Rantoul, KSS/N BL68 N799ALDelt Holdings Orange LLC · Dubuque, IABuilt 1988 · S/N FA-157 N799MCPerry King Air LLC · Perry, GABuilt 1982 · S/N BB-998 N79DMKsg Capital LLC · Casper, WYBuilt 1981 · S/N BB-853 N79EFPonca International LLC · Ponca, ARS/N BB1350 N79TEPollard Aircrfaft Sales Inc · Fort Worth, TXBuilt 1985 · S/N FA-67 N7NANasa Armstrong Flight Research Center · Edwards, CABuilt 1982 · S/N BB-997 N80Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-15 N800BSM&F Western Products Inc · Sulphur Springs, TXBuilt 1998 · S/N BB-1620 N800PKFarmers Oil Co Inc · Anthony, KSBuilt 1981 · S/N BB-982 N800TSPetrie Motor Company Inc · Lake Worth, TXBuilt 1982 · S/N BB-1032 N801NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1983 · S/N BB-1164 N804Abc Aviation LLC · Gonzales, LABuilt 1980 · S/N BB-724

Back to AD 89-19-04 R1