Registered aircraft · 4,243

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-24-01-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-24-01-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-24-01-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-24-01-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-24-01-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-24-01-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.

N10RP4f Aviation LLC · Palmer Lake, COBuilt 1972 · S/N 21059779 N10SBSackett Michael · Nordman, IDBuilt 1975 · S/N 21060920 N10TTHays John J Jr · Denton, TXBuilt 1978 · S/N P21000056 N10WPawsitive Rate LLC · Corpus Christi, TXBuilt 1984 · S/N TJ-448 N10XEBlaikie Thomas B · Kenner, LABuilt 1973 · S/N 340-0221 N10YTN10yt LLC · Missoula, MTBuilt 1976 · S/N 21061460 N1108WEtemadian Ali · Upland, CABuilt 1998 · S/N EA-611 N110CWMile High 1 LLC · Lakeway, TXBuilt 1980 · S/N TK-115 N110HPColt 45 LLC · Tulsa, OKS/N 21059810 N110KMCars Planes And Land LLC · Fuquay Varina, NCBuilt 1983 · S/N 21064800 N110MEAce States Southwest LLC · Stanton, TXBuilt 1979 · S/N EA-17 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N1116ZBear Harbor Aviation LLC · Polson, MTBuilt 1997 · S/N EA-596 N1119TBest Transportation Inc · Newark, NJBuilt 1996 · S/N EA-593 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188 N111NMHineman Land & Cattle Inc · Scott City, KSBuilt 1984 · S/N 46-8508006 N111PCWright Aviation LLC · Molalla, ORBuilt 1999 · S/N EA-639 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111SHRobinson Doyle K · Panhandle, TXBuilt 1976 · S/N 21061270 N111VFCottle John A DBA · Watsonville, CABuilt 1980 · S/N 21064005 N1122BBonanza 1122b LLC · Lake Havasu City, AZBuilt 1979 · S/N EA-2 N1122YD&P Beech Aviation LLC · Concord, CABuilt 1982 · S/N EA-333 N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N112EWKerwin Patrick C · Redwood City, CABuilt 1974 · S/N 21060504 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCBuilt 1977 · S/N 310R1215 N1130QHedges William S · Algona, IABuilt 1997 · S/N EA-598 N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N1133APedota Darien · Northport, ALBuilt 1980 · S/N CE898 N1136VN1136v LLC · Sheridan, WYBuilt 1996 · S/N EA-592 N113AWMontana 1 LLC · Missoula, MTBuilt 1983 · S/N EA-346 N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072 N1141XChancellor Aviation LLC · Billings, MTBuilt 1978 · S/N 414A0215 N114MHVlavic Aviation LLC · Hallandale Beach, FLBuilt 1979 · S/N 414A0458 N114PJRowe John J · Kansas City, MOBuilt 1982 · S/N TJ-410 N115BHBighorn Airways Inc · Sheridan, WYBuilt 1982 · S/N 340A1531 N115EATso Aviation LLC · Conway, ARBuilt 1978 · S/N 340A0484 N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750 N116JWAcvtg Aviation LLC · Wilmington, DEBuilt 1980 · S/N 335-0030 N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021 N1173QMoon Mitchell L · Covington, GAS/N 21059673 N1173WScupham R K · West Des Moines, IABuilt 1983 · S/N 25-0731 N1178UWaco Diamond Star LLC · Niceville, FLS/N 21064671 N117HLZosel Paul J · Bellingham, WABuilt 1976 · S/N 21061649 N117PCalvin Kyle · Wichita, KSBuilt 1976 · S/N 21061407 N117RSJa1 Aviation LLC · Sedan, KSBuilt 1979 · S/N TJ-224 N117UMCn Aviation LLC · Gilbert, AZBuilt 1980 · S/N P21000530 N1181QFly 4 Food Inc · Wilmington, DEBuilt 1972 · S/N 21059681

Back to AD 89-24-01 R1