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.

N11942Puls Kurt V · Valparaiso, INS/N 15075720 N11944Weed Ellen M · Gassaway, WVBuilt 1974 · S/N 15075722 N11946Solari Michael R · Gilroy, CABuilt 1974 · S/N 15075724 N11952Jones William Edward · Scottsdale, AZBuilt 1974 · S/N 15075730 N11953Sanchez Chayanne R · Apex, NCBuilt 1974 · S/N 15075731 N11957Kopecky Dawn D · Center, NDBuilt 1974 · S/N 15075735 N11959Quyser Adil · Edison, NJBuilt 1974 · S/N 15075737 N11962Aeroleasing Inc · Medford, ORBuilt 1974 · S/N 15075740 N1196DAerobat Aoa LLC · Wilmington, DES/N A1520764 N11970Kiforishin Samuel · Westfield, MAS/N 15075748 N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749 N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752 N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423 N11GSHuddleston Edward · Oaktown, INBuilt 1976 · S/N 15078597 N11JTJjj Ventures LLC · Bronx, NYBuilt 1969 · S/N 15071181 N11YSBonanza N5745v LLC · Colorado Springs, COBuilt 1968 · S/N 15068608 N11YWBaldwin William E · Kula, HIBuilt 1970 · S/N 15072351 N1200GHartmann Kaiser Robert · New York, NYBuilt 1972 · S/N 15073901 N1203QMusick John Thomas · White Hall, ARBuilt 1971 · S/N 15072503 N120SSSoutheastern Oklahoma State University · Durant, OKBuilt 1976 · S/N 15078900 N1213RMorgan Robert · Ozark, MOBuilt 1967 · S/N 15064627 N1214QTalapanuri Gokul N · Austin, TXBuilt 1971 · S/N 15072514 N1218QSale Reported · Commerce City, COSale reportedBuilt 1971 · S/N 15072518 N1219QRedeemed Flying Corps Association · Oklahoma City, OKBuilt 1971 · S/N 15072519 N121SSGraber Matthew P · Mountain View, CABuilt 1974 · S/N 15076450 N1222WPlanes Over Plains LLC · Benton, KSBuilt 1974 · S/N 15075991 N1223QAlbertson Alford L · Lemoore, CABuilt 1971 · S/N 15072523 N1224QEmprize LLC · Menasha, WIBuilt 1971 · S/N 15072524 N1227RRegistration Pending · Laie, HIRegistration pendingBuilt 1965 · S/N 15062347 N122CFSouthwest Aviation Specialties LLC · Tulsa, OKS/N 15282778 N1231QMclin Robert J · Mays Landing, NJBuilt 1971 · S/N 15072531 N1232QPeres Kenneth V · Erie, PABuilt 1971 · S/N 15072532 N1233QReach For Skies LLC · San Antonio, TXS/N 15072533 N1236QRawareo LLC · Warsaw, MOBuilt 1971 · S/N 15072536 N1237QN37gd LLC · Fort Myers, FLBuilt 1971 · S/N 15072537 N1239QFleishauer John · Trona, CABuilt 1971 · S/N 15072539 N1241QFly Rite Aviation LLC · Fort Myers, FLBuilt 1971 · S/N 15072541 N1248QHeffernan Kasey C · Torrance, CAS/N 15072548 N124RPPeroyea John L II · Midlothian, TXBuilt 1978 · S/N 15282139 N1250QSantiago Luis R · Waller, TXBuilt 1971 · S/N 15072550 N1254QWeber Joel A · Goddard, KSBuilt 1971 · S/N 15072554 N1255QDrucker Jonathan · Spring Hill, FLBuilt 1971 · S/N 15072555 N1256QRose Kerry D · Liberal, MOBuilt 1971 · S/N 15072556 N1259QBuckles Ryan · Mont Belvieu, TXS/N 15072559 N125AWWaterwings Seaplanes LLC · Hoover, ALBuilt 1967 · S/N 15066417 N1261QLeas Michael A · Bemidji, MNBuilt 1971 · S/N 15072561 N1262QSandford Graves M · Moberly, MOS/N 15072562 N1264QYeghikian Sarmen · Glendale, CABuilt 1971 · S/N 15072564 N1265PElder George · Perryville, MOS/N 15284992 N1265QDumankskii Aviation LLC · Columbus, OHBuilt 1971 · S/N 15072565

Back to AD 2009-10-09 R2