Registered aircraft · 275

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:76-13-11-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:76-13-11-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:76-13-11-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:76-13-11-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:76-13-11-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:76-13-11-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.

N7782SMid Atlantic Soaring Assoc Inc · Frederick, MDBuilt 1969 · S/N 152 N7784SNorth Carolina Soaring Association · Zebulon, NCBuilt 1969 · S/N 154 N7788SBreidenthal Robert E · Seattle, WABuilt 1969 · S/N 158 N8601RFuller Paul H · Powell, OHBuilt 1961 · S/N 105 N8613RClipp John W · Fayetteville, GAS/N 118 N8629RMcdonald Frank G III · Acworth, GABuilt 1962 · S/N 142 N8645RKramer Dean E · Bernville, PABuilt 1962 · S/N 147 N8646RWhitman David L Jr · Centreville, VABuilt 1962 · S/N 148 N8647RLutes Ralph E · Shipshewana, INBuilt 1963 · S/N 149 N8651RSmith Ted · Grant Park, ILBuilt 1962 · S/N 151 N8656RStewarts Aircraft Service · Waynesville, OHBuilt 1963 · S/N 152 N8679RMaglaughlin Ronald D · Udall, KSBuilt 1963 · S/N 162 N8686RChautauqua Soaring Society · Mayville, NYBuilt 1963 · S/N 166 N8687RDennis Polen Aviation Educational Foundation · Granbury, TXS/N 157 N8694RCondon Anthony Brian II · Wichita, KSBuilt 1963 · S/N 167 N91858Crank R Wayne Jr · Shreveport, LABuilt 1947 · S/N 29 N9848EZellers Clyde E · Springfield, ILBuilt 1965 · S/N 229 N9853EHilton Loye Lee · Bullhead City, AZBuilt 1965 · S/N 231 N9903JRaven Nw Llp · Acme, PABuilt 1965 · S/N 237 N9904JKuydendall David E · Roland, IABuilt 1965 · S/N 239 N9905JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1965 · S/N 240 N9918JMueller Douglas G · Boulder City, NVBuilt 1966 · S/N 246 N9919JCollins James C Jr · Whitehouse Station, NJBuilt 1966 · S/N 247 N9943JMartin James D · Graford, TXBuilt 1966 · S/N 242 N999ZZRegistration Pending · Crown Point, INRegistration pendingBuilt 1965 · S/N 225

Back to AD 76-13-11 R1