Registered aircraft · 4,242

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.

N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54CCScythe & Spade Co · Grand View, IDBuilt 1979 · S/N P21000360 N54DFSkywave Associates LLC · Spirit Lake, IABuilt 1972 · S/N 340-0172 N54JQRegistered aircraftN-number assigned (import), not yet registeredS/N 414A0086 N54PSAustin Bill DBA · Sparta, TNBuilt 1980 · S/N P21000492 N550AFAtm One Inc · Tulsa, OKBuilt 1979 · S/N EA-6 N550BRF P And P I Enterprises Inc · Oceanside, CABuilt 1974 · S/N 414-0533 N550JKTaffet Jay · New Orleans, LABuilt 1986 · S/N 46-8608041 N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086 N5511CDss Consulting LLC · Omaha, NEBuilt 1979 · S/N 21063772 N5515CIsland Fliers LLC · Sheridan, WYBuilt 1982 · S/N T30300142 N5516CCarson Kirk · Dalhart, TXBuilt 1979 · S/N 21063774 N5517UKoegel John C · Flint, MIBuilt 1984 · S/N 21064897 N5519UBurlington Veterinary Systems LLC · Burlington, KSBuilt 1990 · S/N E-2519 N5522COswald Ron · Eden Prairie, MNBuilt 1986 · S/N 21064973 N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79 N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236 N5527AMokiy LLC · Aurora, ORBuilt 1985 · S/N P21000861 N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303 N552ZSTuolumne Ridge LLC · Modesto, CABuilt 1983 · S/N EA-343 N5536LAdvance Air LLC · Wichita, KSBuilt 1990 · S/N EA-502 N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785 N5537VWheelzup LLC · San Carlos, CABuilt 1990 · S/N EA-506 N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241 N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092 N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614 N5545AWhelan Peter A · Kettering, OHBuilt 1985 · S/N P21000864 N5546Forster Sebastian Alexander · Elberta, ALBuilt 1979 · S/N EA-53 N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491 N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245 N5552XJjs Aero LLC · Middletown, DES/N E-2521 N5555GSinton Frank J · Durango, COBuilt 1975 · S/N 21061039 N5555SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000417 N555CPFirebird Air LLC · Fulshear, TXBuilt 1979 · S/N 340A0651 N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822 N555PDSw Plains Aviation LLC · Ford, KSBuilt 1980 · S/N EA-61 N555RCCaron Robert M · Fort Pierce, FLBuilt 1976 · S/N 21061303 N555RYA-1 Windshield Inc · Rexburg, IDBuilt 1977 · S/N 21062146 N555SKJld Resources Management LLC · Helena, MTBuilt 1982 · S/N 21064728 N555TYKiefer Karl F · Spring, TXBuilt 1974 · S/N 340-0515 N558PSouth Electrical Inc · Laurinburg, NCBuilt 1982 · S/N TJ-421 N558RSAyelet Aviation LLC · Mackinac Island, MIBuilt 1977 · S/N TK-67 N5598GNorth River Investments Inc · Palmetto, FLBuilt 1990 · S/N EA-503 N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335 N55ABAllan Michael D · Forney, TXBuilt 1974 · S/N 310R0038 N55CMCamille Ventures LLC · Odessa, TXBuilt 1973 · S/N 4140423 N55LPAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0401 N55LTRegistration Pending · Tucson, AZRegistration pendingS/N 414-0926 N55PPChaffey Community College District · Rancho Cucamonga, CABuilt 1972 · S/N 414-0366 N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015

Back to AD 89-24-01 R1