Skip to content

AD 2009-10-09 R2

Registered aircraft · 8,563

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

N11289Phelps Aero Co LLC · Salem, ORBuilt 1973 · S/N 15075302 N11290Safety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 15075303 N11295Bancroft David J · Rio, WIBuilt 1973 · S/N 15075305 N11297Raley James C · Brandon, SDBuilt 1973 · S/N 15075307 N11299Creech John M · Brentwood, TNS/N 15075309 N112NBCarew Enterprises Inc · Appleton, WIBuilt 1973 · S/N 15074671 N112THHanson David J · Elgin, TXS/N 15280204 N11305Logsdon Elizabeth M · Morganfield, KYBuilt 1973 · S/N 15075314 N11308Kaher Kevin G · Menlo Park, CABuilt 1973 · S/N 15075317 N11322Creekside Speech Therapy LLC · Ocala, FLBuilt 1973 · S/N 15075328 N11323Huckabay Timothy J · Red Bluff, CABuilt 1973 · S/N 15075329 N11329Burkhart Verlus L · Fairmont, MNBuilt 1973 · S/N 15075332 N11331Gervais Andre B · Griffin, GABuilt 1973 · S/N 15075334 N11332Byrd Craig Stephen · Laurel, MSS/N 15075335 N1133MRobinson Lanis A · Clanton, ALBuilt 1970 · S/N 15071733 N11351Lanier Equipment Leasing LLC · Gainsville, GABuilt 1973 · S/N 15075343 N11352Kimmel Nathan · Lancaster, PABuilt 1973 · S/N 15075344 N11353Denmark Brooks Mclaughlin · Clayton, NCS/N 15075345 N11356Melton Joseph W · Conway, ARS/N 15075348 N11358Lavalle David · Centerburg, OHBuilt 1973 · S/N 15075350 N1135MLopez Ferco Capdevila · Port Saint Lucie, FLS/N 15071735 N11363Fireland Christopher G · Brownwood, TXS/N 15075354 N11365Kimberk Frederick S · Cambridge, MABuilt 1973 · S/N 15075355 N11366Registration Pending · Jacksonville, FLRegistration pendingBuilt 1973 · S/N 15075356 N11367Canniff Dustin P · Sutton, AKBuilt 1973 · S/N 15075357 N11369Abrams Adrian L · Palmer, AKS/N 15075359 N1136MHiggins Derrick · Arbyrd, MOBuilt 1970 · S/N 15071736 N11371Sale Reported · Thomaston, GASale reportedBuilt 1973 · S/N 15075361 N11373Huffman Aviation LLC · Burleson, TXBuilt 1973 · S/N 15075363 N11380Roush Daniel E · Shoals, INBuilt 1973 · S/N 15075369 N11387Cloud Nine Aviation Inc · Picayune, MSBuilt 1973 · S/N 15075376 N11389Swinnich Kenneth · Wellsboro, PABuilt 1973 · S/N 15075378 N1138ZRegistration Pending · Anchorage, AKRegistration pending, pending cancellationBuilt 1969 · S/N 15069760 N11392Verrill John B · Shelburne, NHBuilt 1974 · S/N 15075381 N11393Brough James P II · Nashua, NHBuilt 1973 · S/N 15075382 N11395Coleman Darryl W · Fayetteville, GABuilt 1973 · S/N 15075384 N11396Jeffries Holdings LLC · Bargersville, INBuilt 1973 · S/N 15075385 N11397Nydam Adam Adrian · Lawrenceburg, KYS/N 15075386 N11399Registered aircraftN-number assigned, not yet registeredS/N 15075388 N113FASale Reported · Dallas, TXSale reported, canceledBuilt 1981 · S/N 15285090 N113NDFox Flight Instruction LLC · Jacksonville, FLBuilt 1967 · S/N 15067823 N113PBRegistration Pending · North Little Rock, ARRegistration pendingBuilt 1976 · S/N 15078263 N113SSSoutheastern Oklahoma State University · Durant, OKBuilt 1975 · S/N 15076645 N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391 N11405Cornelius Steven E · Wasilla, AKBuilt 1973 · S/N 15075394 N11407Harrop Brian · Mesa, AZBuilt 1973 · S/N 15075396 N11409Cambium International Inc · Cary, NCBuilt 1973 · S/N 15075398 N11410South Florida Helicopters Inc · Indiantown, FLS/N 15075399 N11416Woodward Stephen W · Westfield, NYBuilt 1973 · S/N 15075404 N11430De Alwis Godalle W · Riverside, CABuilt 1973 · S/N 15075414

Back to AD 2009-10-09 R2