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.

N416RARegistration Pending · Muskegon, MIRegistration pendingBuilt 1980 · S/N 414A0486 N4171QN4171q LLC · Newport Beach, CABuilt 1972 · S/N 340-0094 N417WCMpi Warehouse Specialty Company Inc · Casper, WYBuilt 1985 · S/N EA 451 N4181TKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320D0081 N418TRAir Sunrise LLC · Mountain View, CABuilt 1982 · S/N 340A1525 N41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798 N41AYHunterdon Aviation Inc · Ringoes, NJBuilt 1978 · S/N 310R1416 N41CEWhats Up Doc Aviation LLC · Alexander, ARBuilt 1978 · S/N 21062872 N41DNNevels Donald L · Everton, MOBuilt 1984 · S/N DLN01 N41EGSal Aviation Inc · Wilmington, DEBuilt 1978 · S/N TK-75 N41GDValiair Lc Trustee · Casper, WYS/N 401B-0218 N41NRSholy Fred · Granada Hills, CAS/N 340A0488 N41TTAlvis Michael Ernie · Sparta, TNBuilt 1972 · S/N 414-0263 N41WTPremiere Aviation Inc · Concord, CABuilt 1982 · S/N 421C1257 N4201CFlying 4 LLC · Whiteville, TNBuilt 1974 · S/N 414-0517 N420HLJannelli Gilbert DBA · Clearwater, FLExpired dealerS/N 402B-0335 N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040 N421AGone Flyin LLC · Wilmington, DEBuilt 1981 · S/N 421C1211 N4228CBurhmann Joel David · Justin, TXBuilt 1974 · S/N 414-0528 N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164 N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534 N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535 N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658 N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270 N424JN424 Juliet LLC · Mesa, AZBuilt 1984 · S/N 46-8408019 N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051 N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266 N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35 N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516 N426LJVenture Air Solutions Inc · Opa Locka, FLBuilt 1981 · S/N 402C0434 N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849 N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528 N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113 N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010 N428AJetpropmontana LLC · Cameron, MTBuilt 1986 · S/N 4608031 N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243 N42AAN42aa LLC · Nantucket, MABuilt 1979 · S/N 402C0238 N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29 N42BDKristoferson John S · Denton, TXBuilt 1988 · S/N 4608122 N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228 N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N42SGPolar Star Co · Wilmington, DES/N 4140927 N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109 N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667 N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011 N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183 N4312VBaron Be 58 LLC · Essex, MTBuilt 1984 · S/N 46-8408012 N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532 N4319MSale Reported · Aptos, CASale reportedBuilt 1983 · S/N 46-8408005

Back to AD 89-24-01 R1