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.

N5266LIlmberger Stephen R · San Leandro, CABuilt 1980 · S/N 15284284 N5267QGibson Aviation Services LLC · Hudson, WIBuilt 1972 · S/N 15073167 N5270QPitman Mark T · Princeton, MNBuilt 1972 · S/N 15073170 N5271QBridges Paul J · Denton, TXBuilt 1972 · S/N 15073171 N5275QSkyfarmer LLC · Culleoka, TNBuilt 1972 · S/N 15073175 N5276MBruehl Kenneth · Roseville, CABuilt 1980 · S/N 15284513 N5276QCarter Nolon D · Kirksville, MOBuilt 1972 · S/N 15073176 N5278QRegistration Pending · Madison, MSRegistration pending, canceledBuilt 1972 · S/N 15073178 N527AAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1976 · S/N 15078287 N5281QHhd Aviation LLC · Hamilton, OHS/N 15073181 N5282BStewart Ronald G · Douglas, MABuilt 1979 · S/N 15283826 N5285QBartell Kevin W · Abbottstown, PABuilt 1972 · S/N 15073185 N5286PSzabo Arthur J · Hurley, NYBuilt 1981 · S/N 15284907 N5286QPasterski Mark F · Chicago, ILBuilt 1972 · S/N 15073186 N5287QRice James L · Mckinney, TXBuilt 1972 · S/N 15073187 N5288QErnie Hall Aviation Museum Inc · Warren, OHS/N 15073188 N5289QNielson Douglas W · East Troy, WIBuilt 1972 · S/N 15073189 N5290QSaso Jan D · Hughson, CABuilt 1972 · S/N 15073190 N5291QQuinn Robert J · Kelleys Island, OHBuilt 1972 · S/N 15073191 N5293QRoberts Jeffrey E · Wheeling, WVBuilt 1972 · S/N 15073193 N5296QSun Baron · Arcadia, CABuilt 1972 · S/N 15073196 N5297MAllard John R · Circleville, OHS/N 15284518 N5297QFalmouth Aviation LLC · North Falmouth, MABuilt 1972 · S/N 15073197 N5298QKirsch Richard D · Lisbon, NDBuilt 1972 · S/N 15073198 N5299QJa Flight Services LLC · Sugar Grove, ILBuilt 1972 · S/N 15073199 N52DRJbpm LLC · Otisfield, MEBuilt 1973 · S/N 15075506 N52FFOflanagan Clancy H · Chowchilla, CAS/N 152-82375 N52JXPinhoc Inc · Winter Garden, FLS/N 15281088 N5300QHopson Larry K · Conroe, TXS/N 15073200 N5301HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15284083 N5303QWest Prairie Aircraft LLC · Weiner, ARBuilt 1972 · S/N 15073203 N5307QSkyway Leasing Inc · Lakeland, FLBuilt 1972 · S/N 15073207 N5308QBig Sky Leasing LLC · Boise, IDBuilt 1972 · S/N 15073208 N5309QSauvageau Daniel W · Roseville, CABuilt 1972 · S/N 15073209 N530CACavalair LLC · San Francisco, CABuilt 1977 · S/N 152-79757 N5310H426th Aero Squadron LLC · Cropwell, ALBuilt 1979 · S/N 15284084 N5312MMoore Aviation Inc · Beaver Falls, PABuilt 1980 · S/N 15284526 N5312QHoogendorn Homer E · Wasilla, AKBuilt 1981 · S/N 15285098 N5314MAlpha Golf Aviation LLC · Naples, FLBuilt 1980 · S/N 15284528 N5314QN5314q LLC · Titusville, FLBuilt 1972 · S/N 15073214 N5315QLessig Bruce D · Casper, WYBuilt 1972 · S/N 15073215 N5318MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284529 N5318QProsperous Holdings LLC · Gainesville, GAS/N 15073218 N5319PRockwell Collins Flight Services Inc · Cedar Rapids, IAS/N 15284912 N5319QPurcell Melinda · Caseyville, ILS/N 15073219 N531CPRegistration Pending · Starkville, MSRegistration pendingBuilt 1973 · S/N 15074997 N5323PCarls Phillip G · Frederick, MDBuilt 1972 · S/N 15073223 N5325QIlm Aviation LLC · Waxahachie, TXBuilt 1972 · S/N 15073225 N53268Sam Aviation LLC · Long Beach, CAS/N 15283525 N5327QLarsen Deziree L · Bay Point, CABuilt 1972 · S/N 15073227

Back to AD 2009-10-09 R2