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.

N714ABHawke Ag Aviation Inc · Oakdale, CABuilt 1976 · S/N 15079017 N714ADRedding Courtland J · Gowen, MIBuilt 1976 · S/N 15079019 N714AEWackman Howard P · Elk Grove, CABuilt 1976 · S/N 15077874 N714AFStoberski John J · Henderson, NVBuilt 1976 · S/N 15079021 N714AGGreenwing Aviation & Welding Co · Lacon, ILBuilt 1976 · S/N 15079022 N714AJMarra Michael A · Carlisle, PABuilt 1976 · S/N 15079024 N714AMRadovanovic Dimitri · Newport Beach, CABuilt 1976 · S/N 15079027 N714APGhiselli William A III Trustee · Woodruff, WIBuilt 1976 · S/N 15079029 N714AQSale Kelly L · Priest River, IDS/N 15079030 N714AZMarsh Gary W · Hopkinsville, KYBuilt 1976 · S/N 15079039 N714BBHunter Jack D · Prattville, ALFirst renewal noticeBuilt 1976 · S/N 15079041 N714BERegistration Pending · Campbell Hall, NYRegistration pendingBuilt 1976 · S/N 15079044 N714BJChandler Scott G · Fortuna, CAFirst renewal noticeBuilt 1976 · S/N 15079047 N714BKZehner Mike W · Boise, IDS/N 15079048 N714BLPeery Harold R · Madill, OKBuilt 1976 · S/N 15079049 N714BNFly Low Aviation LLC · Smithville, MSS/N 15079051 N714BTZielke Michael M · Chuluota, FLBuilt 1976 · S/N 15079056 N714CABlue Steele LLC · Barnegat, NJBuilt 1976 · S/N 15079063 N714CCMckeon Kevin A · Center Moriches, NYS/N 15079065 N714CDVan Ooijen Herman J · Utica, NYBuilt 1976 · S/N 15079066 N714CEWade Bryan · Westfield, INBuilt 1977 · S/N 15079398 N714CFMuir Stephen G · Woodbridge, CABuilt 1976 · S/N 15079068 N714CHGo Leasing Co · Phillipsburg, KSFirst renewal noticeBuilt 1976 · S/N 15079070 N714CJSideline Services LLC · Pearland, TXS/N 15079071 N714CLStrategic Aircraft Management LLC · Fairbanks, AKS/N 15079073 N714CPWentzien Derald E · Newark, DEBuilt 1976 · S/N 15079076 N714CUWestlye Kenneth J · Micanopy, FLBuilt 1976 · S/N 15079081 N714CYGilman Yoel · Aurora, COBuilt 1976 · S/N 15079085 N714DDDunaire LLC · Mechanicsburg, PABuilt 1976 · S/N 15079089 N714DFOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1976 · S/N 15079091 N714DGParr Aviation LLC · Monrovia, MDBuilt 1976 · S/N 15079092 N714DNFour Delta November LLC · Sarasota, FLBuilt 1976 · S/N 15079097 N714DPDelaney John · Cottonwood, CABuilt 1976 · S/N 15079098 N714DQFly Me LLC · Sparta, TNBuilt 1976 · S/N 15079099 N714DRRegistration Pending · Putnam, ILRegistration pendingBuilt 1976 · S/N 15079100 N714DWErdman Daniel J · Hermosa Beach, CAS/N 15079105 N714DXGarner Michael Thompson · Lago Vista, TXBuilt 1976 · S/N 15079106 N714DZAkron Aviation Inc · Malvern, OHBuilt 1976 · S/N 15079108 N714EAGonzalez Loui · Bell Gardens, CABuilt 1976 · S/N 15079109 N714ECSieradzki Richard P · Novi, MIBuilt 1976 · S/N 15079111 N714EHMatthews David G · Middleton, IDBuilt 1976 · S/N 15079116 N714EMDowns Lindsey M · Fayetteville, GABuilt 1976 · S/N 15079120 N714ERB & R Aircraft LLC · Wadsworth, OHBuilt 1976 · S/N 15079124 N714ESDrollinger Michael R · Grandview, WABuilt 1976 · S/N 15079125 N714ETGrenie Arles A · Richland Center, WIBuilt 1976 · S/N 15079126 N714EWBashore Barry A · Pleasant Hill, OHBuilt 1976 · S/N 15079129 N714EZSherrod Robert W Jr · Burleson, TXBuilt 1976 · S/N 15079132 N714FDSolida Christopher · Bunker Hill, INBuilt 1976 · S/N 15079135 N714FFAirgo Inc · Centralia, ILBuilt 1976 · S/N 15079137 N714FGTraining Services Inc T/A · Virginia Beach, VABuilt 1976 · S/N 15079138

Back to AD 2009-10-09 R2