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.

N10FPLoves Park Air LLC · Loves Park, ILS/N 15068636 N10RHGoodson David · Millbrook, ALBuilt 1967 · S/N 15066306 N10VFAce Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282873 N11092Mikulichek Richard L · Silver Lake, MNBuilt 1973 · S/N 15075197 N11097Airborne Aviation LLC · Anchorage, AKBuilt 1973 · S/N 15075198 N110EACenterline Holdings · Camden, DEBuilt 1971 · S/N A1500309 N110FMHorton Maya Patryce · Phoenix, AZBuilt 1975 · S/N 15076809 N110SSEdwards Pacific Aviation Corp · Dover, DEBuilt 1976 · S/N 15078126 N11104Elliott Frank F · Mojave, CABuilt 1973 · S/N 15075200 N11126Laird Charles L · Adelanto, CABuilt 1973 · S/N 15075209 N11128Fletcher Jason · Camden, ARS/N 15075211 N11135Wicks Floyd · Laurelville, OHBuilt 1973 · S/N 15075212 N11138Wen Su Ephraim · Fullerton, CABuilt 1973 · S/N 15075215 N11139Olson Philip D · Garden Plain, KSBuilt 1973 · S/N 15075216 N11142Galion Air Inc · Galion, OHBuilt 1973 · S/N 15075218 N11144Hawkins Larue S · Carrollton, MOBuilt 1973 · S/N 15075220 N11145Martin Walter J · Ocala, FLBuilt 1973 · S/N 15075221 N11146Williams Ryan C · East Helena, MTBuilt 1973 · S/N 15075222 N11149Schmitt Rudy · Brookshire, TXS/N 15075225 N1114TQuellette James L · Plymouth, CTBuilt 1965 · S/N 15061846 N11156Mayer Randal J · Argusville, NDBuilt 1973 · S/N 15075230 N11157Patel Rahul G · Austin, TXBuilt 1973 · S/N 15075231 N11169Cooper Donald L Jr · El Granada, CABuilt 1973 · S/N 15075236 N11173Miller William L Jr · Corinth, MSBuilt 1973 · S/N 15075238 N11183Stancil James T · Jasper, GAS/N 15075243 N11186Round Engine Aero · Nashville, MIS/N 15075245 N11196Clark Joseph C · Avondale, PABuilt 1973 · S/N 15075250 N111HCBennett Miranda Mathis · Fairhope, ALBuilt 1975 · S/N 15077675 N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874 N111TBNeswest Inc · Los Angeles, CABuilt 1968 · S/N 15069477 N11204Hudson Daryl J · Redwood Valley, CABuilt 1973 · S/N 15075252 N11208Cape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1973 · S/N 15075255 N11209Pendragon Aviation LLC · Sylvania, GABuilt 1973 · S/N 15075256 N11227Tribec Inc · Medina, OHBuilt 1973 · S/N 15075262 N11228N11228 LLC · Wheeling, ILBuilt 1973 · S/N 15075263 N11231He Yaling · Grand Prairie, TXS/N 15075266 N11234Universal Airways Inc · Richmond, TXBuilt 1973 · S/N 15075269 N11236Cato Mark M · Clemson, SCBuilt 1973 · S/N 15075271 N11238Laguna Ulises Edgar · Waco, TXBuilt 1973 · S/N 15075272 N11242Crook Robert W · Wichita, KSBuilt 1973 · S/N 15075275 N11243Aeronautical Technical Service Inc · Collierville, TNBuilt 1973 · S/N 15075276 N1124QDuren Virgil W · Bristow, INBuilt 1972 · S/N 15073164 N11251Air Flight Enterprises Inc · S Daytona, FLS/N 15075278 N11257Sale Reported · Eden Prairie, MNSale reportedS/N 15075279 N11262Locke Brian T · Andover, KSBuilt 1973 · S/N 15075282 N11268Bohl Howard M Jr · Long Beach, CABuilt 1973 · S/N 15075286 N11272Williamson Brett O · Essex, MOBuilt 1973 · S/N 15075289 N11281Solovjev Jadranka · Sarasota, FLS/N 15075295 N11283J F Aviation Inc · Joliet, ILBuilt 1973 · S/N 15075297 N11285Northeast Florida Aero Club Inc · Fleming Island, FLBuilt 1973 · S/N 15075299

Back to AD 2009-10-09 R2