Registered aircraft · 62

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

N111BBCypress Aircraft Sales LLC · Clermont, FLBuilt 1975 · S/N 500-0248 N11MNJet Mavericks LLC · Indianapolis, INBuilt 1976 · S/N 500-0266 N138SAMamia Motor Sports Inc · Waller, TXBuilt 1973 · S/N 500-0138 N142DACypress Aircraft Sales LLC · Clermont, FLS/N 501-0004 N145TABon Air Brokerage Company LLC · Lynchburg, VABuilt 1974 · S/N 500-0145 N15JHCentral Virginia Aviation Inc · Petersburg, VABuilt 1974 · S/N 500-0174 N199JKWatts John · Murchison, TXBuilt 1974 · S/N 500-0199 N1DADb Aviation Holdings Group LLC · Fort Lauderdale, FLS/N 500-0288 N200CGTropic Bird Supply Inc · Hypoluxo, FLS/N 500-0230 N233JJSky Trails LLC · Shreveport, LABuilt 1974 · S/N 500-0233 N259DHAirnut LLC · Anchorage, AKS/N 5000259 N269RCAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1973 · S/N 500-0078 N27SFLock Haven Aircraft Sales · Lock Haven, PABuilt 1973 · S/N 500-0064 N28ARN28ar LLC · Kalispell, MTBuilt 1972 · S/N 500-0044 N2RMSki Free Aviation LLC · Austin, TXBuilt 1974 · S/N 500-0153 N305SLongwing LLC · Chandler, AZBuilt 1976 · S/N 5000301 N3095MVsp Citation Holdings LLC · Coral Gables, FLBuilt 1976 · S/N 500-0250 N31LWGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 5000083 N353PJAll Attitude Aviation Inc · Edgewater, FLS/N 500-0104 N397SCBrown Lawson M II DBA · San Diego, CABuilt 1972 · S/N 5000019 N400RMCharlie Tango LLC · Rapid City, SDBuilt 1975 · S/N 500-0290 N409SG & M Island Aviation LLC · Clearwater Beach, FLBuilt 1975 · S/N 500-0238 N411TNAero Specialty Finance LLC · Chesterfield, MOBuilt 1975 · S/N 500-0275 N428WWNsw Investments LLC · Marshall, TXBuilt 1977 · S/N 500-0349 N431LCAraujo Alan · Lynwood, CABuilt 1974 · S/N 500-0177 N442JBCentral Virginia Aviation Inc · Petersburg, VABuilt 1973 · S/N 500-0117 N500DBCrockagator Adventures LLC · Sabina, OHBuilt 1974 · S/N 5000148 N500SKSaphire Air LLC · Utica, NYBuilt 1973 · S/N 500-0129 N500TMBrown Lawson M II DBA · San Diego, CABuilt 1973 · S/N 500-0112 N501DZKutumian Solar Inc · Wilmington, DEBuilt 1972 · S/N 500-0059 N501EJWno Trust Services LLC Trustee · Wilmington, DEBuilt 1973 · S/N 500-0119 N501GBJetcocinas LLC Trustee · Wilmington, DES/N 500-0231 N501MXGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1977 · S/N 5000361 N501RTParatus Jets LLC · Auburn, INBuilt 1971 · S/N 500-0001 N501SSCypress Aircraft Sales LLC · Clermont, FLBuilt 1978 · S/N 5000374 N501ZD501zd LLC · Palm Coast, FLBuilt 1973 · S/N 500-0069 N50AM501 Flyhigh LLC · Maple Plain, MNBuilt 1972 · S/N 500-0041 N53RDPanda Air Inc · Celina, TXBuilt 1981 · S/N 500-0415 N54JVParrott Aviation Inc · Marshall, TXBuilt 1974 · S/N 500-0163 N550LTSchool Board Of Leon County Florida · Tallahassee, FLBuilt 1974 · S/N 500-0184 N550RSRacd Holding LLC · Southwest Ranches, FLS/N 500-0202 N551GBFayetteville Aviation Inc · Fayetteville, TNBuilt 1976 · S/N 500-0314 N552GTSiilats Keith · New York, NYS/N 500-0224 N565CCCypress Aircraft Sales LLC · Clermont, FLBuilt 1973 · S/N 500-0065 N589JKPura Plastic Surgery LLC · Columbia, SCBuilt 1975 · S/N 500-0305 N590RJHalladay Roy · Erie, COBuilt 1974 · S/N 500-0200 N592WPBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 500-0253 N615DSAcurio Michael T · Benton, LAS/N 500-0337 N676DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 5000256 N70TSCypress Aircraft Sales LLC · Clermont, FLS/N 500-0281

Back to AD 73-26-09