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.

N55332Reed Matthew A · Burnsville, MNBuilt 1975 · S/N 15076850 N5533BKnudson Eddie T · Arvada, WYS/N 15283896 N5533GJaeger Robert G · Lake City, FLBuilt 1969 · S/N 15071033 N5537HLine Michael · University Park, MDBuilt 1979 · S/N 15284121 N5544LRegistration Pending · Troy, NYRegistration pendingBuilt 1980 · S/N 15284347 N5545GTinkham Dennis T · Leavenworth, KSBuilt 1969 · S/N 15071045 N5548LUnruly Passengers LLC · Piedmont, SCBuilt 1980 · S/N 15284350 N5549GFrantz Donna Pratt · Ocala, FLBuilt 1969 · S/N 15071049 N5551LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284353 N5552MRegistration Pending · Fayetteville, TNRegistration pendingBuilt 1980 · S/N 15284613 N5557GSegura Richard J III · Henderson, TXS/N 15071057 N555NJCronin John · Stroudsburg, PABuilt 1968 · S/N 15069885 N555STSweeney Steven · Avon, COBuilt 1979 · S/N 15283493 N5562GDurtschi Krista M · Hernando, MSBuilt 1969 · S/N 15071062 N5568GRygwall Brian · Blaine, MNS/N 15071068 N5570GGibbs Robert I · Ravenswood, WVBuilt 1969 · S/N 15071070 N5572GBug Smashers LLC · Winfield, KSBuilt 1969 · S/N 15071072 N5574GCastro Mauro E · Kingsville, TXBuilt 1969 · S/N 15071074 N5576GPruner Michael G · Klamath Falls, ORBuilt 1969 · S/N 15071076 N5578GGilbreath John W · Colt, ARBuilt 1969 · S/N 15071078 N5579GDavila Rudolfo · Runge, TXS/N 15071079 N557AWUnited States Air Force · Usaf Academy, COBuilt 1975 · S/N 15077067 N557SHUnited States Air Force · Usaf Academy, COBuilt 1971 · S/N 15072617 N557THUnited States Air Force · Usaf Academy, COBuilt 1975 · S/N 15077111 N5581GC&C Aero LLC · Billings, MTBuilt 1969 · S/N 15071081 N5582GPilot Am LLC · East Elmhurst, NYBuilt 1969 · S/N 15071082 N5582HHendrickson Justin N · Richmond, INS/N 15066290 N5588GSale Reported · Washington, UTSale reportedS/N 15071088 N5590GDelci Dino J · Tempe, AZBuilt 1969 · S/N 15071090 N5592GFleming Randy · Concord, NCS/N 15071092 N5593GDebartolo Samuel · Swampscott, MABuilt 1969 · S/N 15071093 N5594GDavis Joseph S · Andalusia, ALBuilt 1969 · S/N 15071094 N5595GZortman Micky P · Mexico, MOS/N 15071095 N5597GRegistration Pending · Washington, UTRegistration pendingBuilt 1969 · S/N 15071097 N5600GChimera Air Inc · Maumee, OHBuilt 1969 · S/N 15071100 N5605GMartinez Ivan A · Oro Valley, AZS/N 15071105 N5606GPinho Michel A · Santa Barbara, CABuilt 1969 · S/N 15071106 N560MAKrauss Solutions LLC · Debary, FLBuilt 1966 · S/N 15065142 N560PCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281915 N560SFAllen Adam W · Sutter Creek, CABuilt 1974 · S/N 15075865 N5610GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071110 N5612GNelson Daniel J · Ladd, ILBuilt 1969 · S/N 15071112 N561GSSandberg David C · Auke Bay, AKBuilt 1969 · S/N 15071487 N5622Nichols Stephen S · Hartland, WIBuilt 1966 · S/N 15065525 N5626GGreer Management LLC · Salem, ORBuilt 1969 · S/N 15071126 N5628GJewell Jonathan T · Paducah, KYBuilt 1969 · S/N 15071128 N562GSHermann Andrew L · Kindred, NDBuilt 1969 · S/N 15071509 N563FSPatterson Marshall S · Tuscumbia, ALBuilt 1967 · S/N 15066188 N563GMarsh Matthew · Cleveland, ALBuilt 1968 · S/N 15068275 N563GSGilderhus Edwin T · Oberon, NDS/N 15071468

Back to AD 2009-10-09 R2