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.

N564DSLopez John · Prole, IAS/N 15066564 N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276 N564QLSimcic Kathryn C · Grain Valley, MOBuilt 1969 · S/N 15070570 N5653GCavanaugh Joseph Rex · Alvin, TXBuilt 1969 · S/N 15071153 N5654GNorman Charles E · Zanesville, OHBuilt 1969 · S/N 15071154 N5655GAnderson Kevin G · Pleasant Hill, CABuilt 1969 · S/N 15071155 N5656GLet There Be Flight LLC · Portage, MIBuilt 1969 · S/N 15071156 N5659GLacy Melodi J · Swanton, VTBuilt 1969 · S/N 15071159 N565WWard Ann Marie · Seattle, WABuilt 1978 · S/N 15281812 N5660GLawrence Corey R · Bourbon, MOBuilt 1969 · S/N 15071160 N566GSPomeroy Cattle Ranch LLC · Kalispell, MTS/N 15071446 N5672GHarrold Adam T · New Waterford, OHBuilt 1969 · S/N 15071172 N5675GGray Mark J · Muncie, INBuilt 1969 · S/N 15071175 N5676GSchmidt Gary L · Afton, MNS/N 15071176 N5677GFredenburg Justin N · Edgeley, NDS/N 15071177 N567GSFlying R LLC · Spokane Valley, WABuilt 1971 · S/N 15072751 N567KSKing Sky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15282634 N5680PHaro Roger E · Eden Prairie, MNBuilt 1967 · S/N 15064867 N5683GCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 15071183 N5687GChilders Roderick G · Red Banks, MSBuilt 1969 · S/N 15071187 N5688GFriends Of Jesus · Poughkeepsie, ARFirst renewal noticeBuilt 1969 · S/N 15071188 N5693GScott Jerry · Wingate, TXBuilt 1969 · S/N 15071193 N5694GN528r LLC · Auburn, ALBuilt 1969 · S/N 15071194 N5696GLowry David N · Fairport, NYBuilt 1969 · S/N 15071196 N5698GKessler Frank J Jr · Gallatin, TNS/N 15071198 N569APotopowitz William III · Niantic, CTS/N 15070351 N569GSTwin Cities Flight Training Inc · Blaine, MNBuilt 1971 · S/N 15072763 N569NEMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 15282580 N56QWJefferson City Aviation Inc · Jefferson City, MOBuilt 1976 · S/N 150-78863 N5702GRandolph-Graham Monica L · Roanoke, TXBuilt 1969 · S/N 15071202 N570UABohl Howard M · Temecula, CAS/N 15067929 N5718GSwietek Robert E · Grand Rapids, MIBuilt 1969 · S/N 15071218 N571VHVan Hoy Jeffrey D · Knightstown, INBuilt 1965 · S/N 15062392 N5722GSchmitt Rudy · Bulverde, TXBuilt 1969 · S/N 15071222 N5724GCrnic John F · Kirksville, MOBuilt 1969 · S/N 15071224 N5736GGagana Aviation LLC · Leander, TXBuilt 1969 · S/N 15071236 N5740GAdventist World Aviation · Wilson, NCBuilt 1969 · S/N 15071240 N5745GPettis Gary D · Lula, GABuilt 1969 · S/N 15071245 N5748GKozar Theodore · Connellsville, PABuilt 1969 · S/N 15071248 N5749GPorter John W · Center, TXBuilt 1969 · S/N 15071249 N574AJRippel Aviation LLC · La Salle, ILBuilt 1975 · S/N 15077148 N5750GHolt Wayne A · Waterford, MEBuilt 1969 · S/N 15071250 N5757GWill Cutter G · San Angelo, TXBuilt 1969 · S/N 15071257 N5760GVan De Walle Matthew W · San Antonio, TXBuilt 1969 · S/N 15071260 N5765GQuiring Jason L · Terrell, NCS/N 15071265 N5768GBilton Nicholas J · Bozeman, MTBuilt 1969 · S/N 15071268 N5769GHarper William M Jr · Foley, ALBuilt 1969 · S/N 15071269 N5770GVoller Jim A · Strasburg, NDS/N 15071270 N5772GBean Dale R · Moreno Valley, CABuilt 1969 · S/N 15071272 N5774GHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071274

Back to AD 2009-10-09 R2