Registered aircraft · 468

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

N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064 N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019 N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169 N100YGAnderton Doyle M · Royse City, TXS/N 31P-7530010 N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186 N102WHStuddiford James A · Lithia, FLS/N 31-7952066 N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112 N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210 N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056 N1071AOcean Group LLC · Plantation, FLBuilt 1979 · S/N 31-7952195 N108BHEmt Bahamas Holdings LLC · Greer, SCS/N 31-214 N108JLStar Marianas Aviation School Inc · Saipan, MPBuilt 1983 · S/N 31-8352028 N111CFGsm Tax & Insurance Inc · Naples, FLBuilt 1976 · S/N 31-7652105 N111GAGeorges Aviation Services Inc · Honolulu, HIBuilt 1981 · S/N 31-8152050 N111UCRcht LLC · Mason, OHBuilt 1979 · S/N 31-7952190 N114NCFair Air Inc · Bloomfield Hills, MIS/N 31-8252009 N114PRC W 3 LLC · San Juan, PRBuilt 1981 · S/N 31-8152088 N114SACustom Air International LLC · Homestead, FLBuilt 1980 · S/N 31-8052053 N1187KLove Simplicity · Princeville, HIBuilt 1980 · S/N 318052175 N118MCAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952161 N120JDLamb Aviation LLC · Perris, CABuilt 1981 · S/N 31-8152179 N120MLMrl Aviation LLC · Wilmington, DEBuilt 1977 · S/N 31-7752091 N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N123JHFti Group LLC · Norman, OKS/N 31P-7630010 N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103 N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242 N1250CBravan Aviation · Fort Lauderdale, FLS/N 31P-7530011 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N12GFStauffer Michael S · Wichita Falls, TXBuilt 1973 · S/N 31P-7300134 N130BVTheophanis Charters LLC · Stuart, FLS/N 31-7952216 N131MPN Registration Service LLC Trustee · Sanford, NCS/N 31P-7400193 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N135PBD&R Holdings LLC · Kailua, HIS/N 31-7952035 N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001 N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009 N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411 N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051 N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117 N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903 N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109 N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005 N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060 N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036 N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230 N158JDNavajo N158jd LLC · Wilmington, DEBuilt 1981 · S/N 318152104 N159DSynapse USA LLC · Mesa, AZBuilt 1974 · S/N 31P7530012

Back to AD 75-09-10