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.

N67VMCreeque Alley Ventures LLC · Missoula, MTBuilt 1980 · S/N P21000568 N6801THoffman Peter · Monrovia, CABuilt 1984 · S/N EA-429 N6814RBbc414a LLC · Alton Bay, NHBuilt 1981 · S/N 414A0638 N6815TL A Flyers LLC · Monticello, ARBuilt 1981 · S/N 414A0645 N6817DGlasscock Charles W Jr · Elm Grove, LABuilt 1981 · S/N 414A0656 N6818XBlue Skys Aero LLC · Vermilion, OHBuilt 1981 · S/N 414A0663 N681RCObsidian Air LLC · Pompano Beach, FLS/N 402C0002 N6822UKw Aircraft LLC · Judson, TXS/N 414A0808 N68233Sunbird Aviation Inc · Bozeman, MTBuilt 1981 · S/N 340A1273 N68236Vaughn Air LLC · Hillsboro, ORBuilt 1981 · S/N 340A1275 N68239Northeast Skywagon LLC · Pittsfield, MEBuilt 1981 · S/N 340A1276 N6823DS A Fliers LLC · Venice, FLBuilt 1980 · S/N 340A1042 N6823FTreetop Aviation LLC · Wilson, NCBuilt 1980 · S/N 340A1043 N68245Registration Pending · Anderson, SCRegistration pendingBuilt 1980 · S/N 340A1204 N6824LEnvironmental Evolutions Transportation Inc · Robstown, TXBuilt 1980 · S/N 340A1201 N6825TSongbird Aviation LLC · Larkspur, CABuilt 1981 · S/N 340A1208 N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840 N6826LThomas Faulhaber Pc · La Veta, COBuilt 1980 · S/N 340A1213 N6826QBeechcraft Heritage Museum · Tullahoma, TNBuilt 1964 · S/N D-7450 N6827LDuke Aviation LLC · Woodridge, ILBuilt 1980 · S/N 340A1219 N6828PSnowfox Insurance Inc · Pace, FLBuilt 1981 · S/N 340A1226 N6828RDaves Aircraft LLC · Eden, NCBuilt 1981 · S/N 340A1227 N6829WGroupe Caraibe LLC · Wilmington, DEBuilt 1984 · S/N EA-407 N682JDWindward Air LLC · Orlando, FLBuilt 1981 · S/N 414A0802 N682JSIflyhigh LLC · Phoenix, AZBuilt 1981 · S/N 340A1237 N6830LN661w Air LLC · Dalton, GABuilt 1980 · S/N 310R2102 N6834APlum Family Buildings LLC · Marengo, IABuilt 1984 · S/N EA-408 N68379Express Carrier LLC · St Thomas, VIBuilt 1981 · S/N 402C0469 N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346 N68391Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0483 N6839YRichland Aviation Inc · Sidney, MTBuilt 1981 · S/N 402C0481 N683SDMurray Steven L · Webster, NYBuilt 1980 · S/N EA-148 N683TM007 Arkansas Aviation LLC · Jonesboro, ARBuilt 1979 · S/N 414A0237 N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147 N6850BJennings Donald J · Gypsum, COS/N 21062845 N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255 N685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 310R-1375 N6867CHelms Foodservice Inc · Lake City, FLBuilt 1980 · S/N 335-0061 N68707Ascp Blue Skies LLC · Columbia, MOS/N 340A1515 N6870MApplied Science Services Corp · Woodland Hills, CABuilt 1977 · S/N 21061998 N68717Horst Paul A · Clarkrange, TNBuilt 1982 · S/N 340A1526 N6871DPickett Aviation LLC · Brownsboro, ALBuilt 1982 · S/N 340A1519 N68752Hyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0518 N6875DHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0511 N6879RHyannis Air Service Inc · Hyannis, MAS/N 402C0611 N687SAGerstein Lee · Park City, UTBuilt 2001 · S/N EA-687 N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603 N6899BCowgill Robert W · Amissville, VABuilt 1978 · S/N 21062852 N68BMDavenport Donald · North Las Vegas, NVBuilt 1977 · S/N 21062441 N68EAPav East LLC · Camden, DEBuilt 1985 · S/N P21000837

Back to AD 89-24-01 R1