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.

N72006Detmer Darren D · Chappell Hill, TXBuilt 1984 · S/N TJ-460 N7200HHefelfinger James F · Port Orange, FLBuilt 1984 · S/N EA-426 N7202MG&M Baron Aviation LLC · Bradenton, FLS/N TJ-456 N7204EOverit Air LLC · Las Vegas, NVBuilt 1984 · S/N TJ-457 N72053South Aircraft Leasing Inc · Wilmington, DEBuilt 1974 · S/N 402B-0587 N7205EAl Force 1 LLC · North Salt Lake, UTBuilt 1984 · S/N TJ-458 N7206DCrazy Plane LLC · Saint Augustine, FLBuilt 1984 · S/N EA-435 N7207LSparkman Aviation · Odessa, TXBuilt 1984 · S/N EA-438 N721Department Of The Interior · Boise, IDBuilt 1981 · S/N U20606256 N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207 N721YGRunway Aviation Flight Training USA Corp · Rockwall, TXBuilt 1974 · S/N 340-0342 N7222LAllmon William C · Las Vegas, NVFirst renewal noticeS/N TJ-484 N7225HCosmo Plastics Company · Pepper Pike, OHBuilt 1985 · S/N TJ-485 N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332 N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651 N72412Intricate Bay Operating LLC · Saylorsburg, PABuilt 1969 · S/N U206-1396 N7243ABc Express LLC · Santa Barbara, CAS/N TJ-494 N724BDEdelson David · New York, NYBuilt 1980 · S/N TJ-266 N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213 N7257NPeterson Winston Roy II · Arbuckle, CABuilt 1976 · S/N U20603588 N7258ESchreher Jeremy A · Richmond, VABuilt 1986 · S/N EA-455 N726BADangerstik Corp · Olympic Valley, CABuilt 1979 · S/N TJ-214 N726HSSpmhrt 206 LLC · East Bernard, TXS/N U20606947 N726TJJohnstone Thomas T · Panama City, FLBuilt 1976 · S/N TJ-80 N727FValiair Ltd Co Trustee · Casper, WYBuilt 1981 · S/N P21000727 N727LTFoster Jeffrey · Baton Rouge, LABuilt 1980 · S/N TJ-313 N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140 N728CTBerns Ridge Service LLC · Whittier, CABuilt 1982 · S/N 340A1533 N728DSTebeaux William Jene · College Station, TXBuilt 1986 · S/N 4608047 N72CGGarvin Carroll E · Scottsdale, AZBuilt 1980 · S/N TJ-264 N72CUKuhlke K Lee · Englewood, COBuilt 2001 · S/N EA-673 N72DTMalibu Aviation Inc · Wichita, KSBuilt 1985 · S/N 46-8508084 N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333 N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513 N72LRSchnell Michael L · Spearman, TXBuilt 2001 · S/N EA-676 N72SCLsa Aircraft Holdings LLC · Houston, TXBuilt 1984 · S/N TJ-477 N72VTNot Enuf LLC · Jackson, WYBuilt 1979 · S/N 340A0654 N7303NJordan James D · Paradise, TXBuilt 1979 · S/N 21063218 N7305URyan Air Inc · Anchorage, AKBuilt 1977 · S/N 20700392 N730AFB Fam LLC · Texico, NMBuilt 1976 · S/N 414-0853 N731BJArmis Strategies LLC · Hartwell, GABuilt 1979 · S/N P21000437 N731CBAnesthesia Aviation LLC · Leesburg, VAS/N P21000545 N731CYSan Diego Air Service · San Diego, CABuilt 1979 · S/N P21000442 N731DSYou And Me LLC · Sedalia, MOBuilt 1979 · S/N P21000446 N731FEJones Marilyn W · Collinsville, CTBuilt 1979 · S/N P21000450 N731FKQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000452 N731FTMillican Clifford A · Burleson, TXBuilt 1979 · S/N P21000454 N731GCLavalley Asset Management Inc · Potsdam, NYBuilt 1979 · S/N P21000457 N731GVSolomon Mark Trustee · Wilmington, DEBuilt 1999 · S/N EA-631 N731HRBrennan Timothy · San Francisco, CABuilt 1980 · S/N P21000464

Back to AD 89-24-01 R1