Registered aircraft · 1,913

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:74-18-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-08') 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:74-18-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-08')
  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:74-18-08')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-08')
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.

N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210 N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052 N1007XD&R LLC · Emory, TXS/N 34-7570182 N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116 N10162Crespi Tony D · Meriden, CTBuilt 1981 · S/N 25-0561 N10165N10165 Corp Trustee · Wilmington, DEBuilt 1981 · S/N 25-0562 N10167Sterling Air LLC · La Quinta, CABuilt 1981 · S/N 25-0563 N1016UBlueskys Inc · Wilmington, DEBuilt 1982 · S/N 25-0727 N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547 N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615 N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564 N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631 N1026UMooneylust LLC · Springfield, MOBuilt 1989 · S/N 25-1215 N1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216 N1041GN1041g LLC · Charlotte, NCBuilt 1981 · S/N 25-0567 N1047AHolt Sheet Metal Inc · Durango, COBuilt 1981 · S/N 25-0571 N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049 N1049DChihuahua Airport Partners Lp · Plano, TXBuilt 1975 · S/N 0015 N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048 N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195 N10691Reed Kerr Aviation Inc · Wilmington, DEBuilt 1984 · S/N 34-8433050 N106QIntegrity Aero LLC · Boerne, TXS/N 25-1208 N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199 N1070ZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 25-1222 N1077YPainter No 2 LLC · Hillman, MIBuilt 1981 · S/N 25-0575 N1079BMander Ronald L · Mooresville, NCBuilt 1981 · S/N 25-0577 N107ABHobart Aviation Inc · Akron, OHBuilt 1977 · S/N 34-7770341 N1082YCalvey Eric W · Abingdon, MDS/N 25-0582 N10851Curran Michael F · Windham, NHS/N 25-1229 N1085CBentley Geoffrey D · Marco Island, FLBuilt 1990 · S/N 25-1228 N1085NWong Sonja M · Alameda, CABuilt 1981 · S/N 25-0583 N1090QArrow 051 LLC · Leicester, NCBuilt 1977 · S/N 28R-7703051 N1091NDunkin Stevan R · Emmett, IDBuilt 1989 · S/N 25-1220 N109RFBartley Scott C · Chaska, MNBuilt 1984 · S/N 25-0819 N10BNBlack Thomas D DBA · Clearwater, FLBuilt 1975 · S/N 34-7570050 N10PBNeves Frank Jr · North Miami Beach, FLBuilt 1974 · S/N 34-7570031 N1106XVan Vleet Merlin D · Kingman, AZBuilt 1975 · S/N 34-7570212 N110CAFargo Jet Center LLC · Fargo, NDBuilt 1975 · S/N 34-7570219 N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117 N110PAPostupack Peter Jr · New Cumberland, PAS/N 25-2007 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N111PHGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 34-7970001 N111RXThompson William · Tampa, FLS/N 347770134 N111SMMuller Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 34-7770333 N1131QFarm Country Air LLC · Jefferson, IABuilt 1977 · S/N 28R-7703053 N1139ZGonet John Charles · Southwick, MABuilt 1981 · S/N 25-0617 N113DFRegistered aircraftBuilt 1998 · S/N 3449062

Back to AD 74-18-08