Skip to content

AD 2009-10-09 R2

Registered aircraft · 8,565

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.

N6597GOff Airport Adventures LLC · Saint David, AZBuilt 1971 · S/N 15072097 N65981Registration Pending · Dubuque, IARegistration pendingBuilt 1974 · S/N 15075756 N65984Woelbing Aviation LLC · Franksville, WIBuilt 1974 · S/N 15075758 N65985Moreira Hiosvany · Pensacola, FLS/N 15075759 N65986Ahern Michael · El Reno, OKBuilt 1974 · S/N 15075760 N65997Dalton John C · Hernando, MSBuilt 1974 · S/N 15075764 N6599FSiebe James E · Moscow, IDBuilt 1966 · S/N 15063199 N65JXFlight World Inc · San Juan, PRBuilt 1980 · S/N 15284244 N66006Registration Pending · Souderton, PARegistration pendingBuilt 1974 · S/N 15075769 N66009Cowan Ronnie C · Glasgow, KYBuilt 1974 · S/N 15075772 N6600DMarsh John E · Washington, DCS/N 15072100 N6600FSeiger Thomas W · Medford, ORS/N 15063200 N66017Engelhardt John · Kingwood, TXFirst renewal noticeBuilt 1974 · S/N 15075778 N66022Pickett Ronald K II · Mc Alpin, FLBuilt 1974 · S/N 15075782 N6602FBeasley Thomas · Fort Worth, TXS/N 15063202 N6603FAres Andrey · Fort Lauderdale, FLBuilt 1966 · S/N 15063203 N6603SColonial Air Inc · New Bedford, MABuilt 1967 · S/N 15067403 N66042Hudson Steven E · Junction City, KSBuilt 1974 · S/N 15075795 N66047Shiles Darrell J · Baltimore, MDBuilt 1974 · S/N 15075799 N66054Wooten Jeffrey B · Rock Hill, SCBuilt 1974 · S/N 15075802 N66055Tas Aviation Aircraft Sales LLC · Defiance, OHBuilt 1974 · S/N 15075803 N6605PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285037 N66063Taylor Jonathon K · Carlsbad, CABuilt 1974 · S/N 15075808 N66064Radford Lawrence · Scottsdale, AZBuilt 1974 · S/N 15075809 N66069Vintage Wings Aircraft LLC · Centerpoint, INBuilt 1974 · S/N 15075812 N6606GRoach Georgia L · Dewitt, ARBuilt 1970 · S/N 15072106 N66073Jenkins Jerome D · Gays Mills, WIS/N 15075815 N66075Malachi Israel · Superior, WIBuilt 1974 · S/N 15075816 N66077Johnson Jerry L · Lewiston, IDBuilt 1974 · S/N 15075817 N66079Dacy Patrick J · Huntley, ILS/N 15075819 N6607FRegistered aircraftBuilt 1966 · S/N 15063207 N6607LGll Plane LLC · Ocala, FLBuilt 1980 · S/N 15284461 N66086Barbosa Manuel Moreira · Apple Valley, MNBuilt 1974 · S/N 15075823 N66088James M Carrigan LLC · Sanibel, FLBuilt 1974 · S/N 15075825 N66089Powell Brett · Bennett, COBuilt 1974 · S/N 15075826 N6608BTucker William C · Phoenix, AZBuilt 1979 · S/N 15283959 N66092Grinberg Dmitry · Austin, TXBuilt 1974 · S/N 15075827 N66093Ponderosa Land Surveys LLC · Lead, SDBuilt 1974 · S/N 15075828 N66094Nelson Harry L · Towner, NDBuilt 1974 · S/N 15075829 N66099Maddock Jay A · Sugar Grove, ILBuilt 1974 · S/N 15075832 N6609FMcalexander William Dean · Conover, OHBuilt 1966 · S/N 15063209 N66105Everett Stanley J · Cumming, GABuilt 1974 · S/N 15075838 N6610FCabala Nicholas C · Bay City, MIBuilt 1966 · S/N 15063210 N6610GThomas Charles L · Yankton, SDBuilt 1970 · S/N 15072110 N66110Krikorian Philip · Fresno, CABuilt 1974 · S/N 15075843 N66115Hayes Orris E · Betsy Layne, KYBuilt 1974 · S/N 15075846 N66118Segarra Jo Ann · Ponce, PRFirst renewal noticeBuilt 1974 · S/N 15075849 N66119Northwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 15075850 N6611FMehsling Thomas C · Byers, COBuilt 1966 · S/N 15063211 N66120Osten Albert M · Poughkeepsie, NYBuilt 1974 · S/N 15075851

Back to AD 2009-10-09 R2