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.

N63665101 Flight LLC · Waterford, MIBuilt 1975 · S/N 15077466 N6366GTownson Charlotte K · Cisco, TXBuilt 1970 · S/N 15071866 N6366KCastano Jose R · Sleepy Hollow, NYBuilt 1975 · S/N 15077667 N63670Uflyorlando Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 15077471 N63671N63671 LLC · Austin, TXBuilt 1975 · S/N 15077472 N63677Weir Ryan Lee · Buckley, WABuilt 1975 · S/N 15077477 N63679Goldman Jacob · Bend, ORBuilt 1975 · S/N 15077479 N6367KPethes Ted · Las Vegas, NVS/N 15077668 N6367QCc Aviation Inc · Tracy, CABuilt 1981 · S/N 15285236 N6367SLogtime Flight LLC · Lancaster, TXBuilt 1967 · S/N 15067167 N6368QRegistration Pending · Kalispell, MTRegistration pendingS/N 15285237 N6368SMommsen Robert V · Ketchikan, AKS/N 15067168 N6374GLilbit Industries LLC · Oklahoma City, OKBuilt 1970 · S/N 15071874 N6375HRound Engine Aero · Nashville, MIS/N 15284162 N6376MMattingly Eddie D · Port Charlotte, FLBuilt 1980 · S/N 15284698 N6377BMarsicano Robert M · Danbury, CTBuilt 1979 · S/N 15283926 N6377SVillalba Raymond · Spring, TXBuilt 1967 · S/N 15067177 N6378GHigh Exposure Inc · Wilmington, DEBuilt 1970 · S/N 15071878 N6378MFlowers Jonathan Barak · Kent, WABuilt 1980 · S/N 15284700 N6379MRichmor Aviation Inc · Scotia, NYS/N 15284701 N6379SMcdonald Gregory S · Mena, ARBuilt 1967 · S/N 15067179 N6383HWest Brian L · Creston, IABuilt 1973 · S/N 15074956 N6383KMock Joseph R · Huntsville, TXBuilt 1975 · S/N 15077677 N6383SNightingale Matthew · Rancho Cucamonga, CABuilt 1967 · S/N 15067183 N6384SSalter William Jeffrey · New Smyrna Beach, FLS/N 15067184 N6385SPalmer Dana G · Gatesville, TXS/N 15067185 N6386GSonafrank Eric · Somerset, INBuilt 1970 · S/N 15071886 N6387BSparrow Hawk Aviation LLC · Moraine, OHBuilt 1979 · S/N 15283927 N6388GGaller Frank G · Elysian, MNBuilt 1970 · S/N 15071888 N6389BGc Aviation Services-1 LLC · Miamisburg, OHS/N 15283928 N6389GHagen Alfred · Bensalem, PABuilt 1970 · S/N 15071889 N6390SStraub Aircraft Holdings LLC · Overland Park, KSBuilt 1967 · S/N 15067190 N6398GCrowned Eagle Aviation LLC · South Saint Paul, MNBuilt 1970 · S/N 150-71898 N6398PShelton Dale E · West Frankfort, ILBuilt 1981 · S/N 15285011 N6399MZimmerman Don · Austin, TXS/N 15284709 N63RWSmith Jacques F · Anchorage, AKBuilt 1978 · S/N 15280763 N6400FAirplanes Unlimited LLC · Jackson, TNBuilt 1966 · S/N 15063000 N6400GCollier James S · Jesup, GABuilt 1970 · S/N 15071900 N6400QHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285244 N6401FPfd Aviation LLC · Sheridan, WYBuilt 1966 · S/N 15063001 N6402FMaier Andrew J · Barnesville, MNBuilt 1965 · S/N 15063002 N6403FFertile Flying Club Inc · Fertile, MNBuilt 1966 · S/N 15063003 N6403GKassel Willard C · Sicily Island, LAS/N 15071903 N6403MPlane N Simple Aviation LLC · Los Angeles, CABuilt 1980 · S/N 15284711 N6404GWarrior Aviation LLC · Prior Lake, MNBuilt 1970 · S/N 15071904 N6405GArmond Richard J · Thousand Oaks, CABuilt 1970 · S/N 15071905 N6406KWandell Daniel J · Murfreesboro, TNBuilt 1975 · S/N 15077687 N6408KShowah Michael F · Scottsdale, AZS/N 15077688 N6409FStatusair LLC · Mount Arlington, NJBuilt 1966 · S/N 15063009 N6409MCendejas Agustin · Chino, CABuilt 1980 · S/N 15284713

Back to AD 2009-10-09 R2