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.

N3281JRegistration Pending · Oakland, ORRegistration pendingBuilt 1966 · S/N 15065981 N3281RNowicki Stanislaw · Cottonwood Heights, UTS/N 15284363 N3286JJohnson David W · Biwabik, MNS/N 15065986 N3288JSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15065988 N32897Mach Point Nine LLC · Phoenix, AZS/N 15065989 N3290JFitzgerald Jacob J · Pullman, WABuilt 1966 · S/N 15065990 N3291ZMiller Andy D · Marana, AZBuilt 1973 · S/N 15075105 N3295JClonts Kim E · Knox City, TXS/N 15065995 N3299JEdwards Wallace · Commerce, MIS/N 15065999 N3299VChannel City Flyers Inc · Goleta, CABuilt 1974 · S/N 15076452 N3300JIngram Jay Wallis · El Paso, TXBuilt 1966 · S/N 15066000 N3301VErhard Robert T · Granville, OHBuilt 1974 · S/N 15076453 N3302JWignot Andrew R · Oceanside, CABuilt 1966 · S/N 15066002 N3303JWilliams Charles S · Pearland, TXBuilt 1967 · S/N 15066003 N3306JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15066006 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3312JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15066012 N3313JEsckelson Eric S · Cass City, MIS/N 15066013 N3313VAviation Enterprises Inc · Springfield, MOBuilt 1974 · S/N 15076457 N3314VCurtiss Steve L · Fortine, MTS/N 15076458 N3315JFlying Shiba Inus LLC · Dallas, TXS/N 15066015 N3316JChipollini Jorge · Springdale, ARBuilt 1966 · S/N 15066016 N331JCCsp Aviation Holdings LLC · Dallas, TXBuilt 1966 · S/N 15064821 N3320JPollman Justin A · Sherwood, NDS/N 15066020 N3321JFulton Ricky L · Alex, OKBuilt 1966 · S/N 15066021 N3321VRegistered aircraftBuilt 1974 · S/N 15076462 N3323JRichards Amy L · Union City, INBuilt 1966 · S/N 15066023 N333Grullon Guarocuya · Van Buren Twp, MIBuilt 1980 · S/N A1520963 N3333JUrban Aviation Services Inc · Paxton, MABuilt 1966 · S/N 15066033 N333ADRegistration Pending · Lynchburg, VARegistration pending, pending cancellationS/N 15078954 N333MWThird Oak Aviation LLC · Statham, GABuilt 1966 · S/N 15063324 N333NEEarle Norman R · Hastings, FLS/N A1520852 N333QAFirth Lynn C · Auburn, NHBuilt 1968 · S/N 15069983 N333SHVitez David D · Morgantown, WVBuilt 1969 · S/N 15070617 N333SSCumulus Aviation Services LLC · Port Orange, FLBuilt 1980 · S/N 15284311 N333UMUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1980 · S/N 15284751 N333VBHumes Garrett D · Leesburg, FLBuilt 1975 · S/N 15076623 N333WGWilliams Samantha L · Kendallville, INS/N 15065465 N3340JSteiner William Mark · Newport Beach, CABuilt 1966 · S/N 15066040 N3341VAreeckal Rejee · Mcallen, TXBuilt 1974 · S/N 15076467 N3343JAndresen Paul S · Chandler, AZS/N 15066043 N3343VVitale Paul P · Green Valley, AZBuilt 1974 · S/N 15076468 N3344JSaitto Jeffrey M · Media, PAS/N 15066044 N3356VCavu Pilot LLC · Powell, TNBuilt 1974 · S/N 15076471 N3357JHagghult Christer · Bonney Lake, WABuilt 1967 · S/N 15066057 N3358JBlue Chip Enterprises Inc · Clayton, NCBuilt 1967 · S/N 15066058 N3359JGaler Charles J · Irvington, ALBuilt 1967 · S/N 15066059 N3359VArcher Lee R · Redondo Beach, CABuilt 1974 · S/N 15076473 N3360JStewart Roger · Lenexa, KSBuilt 1967 · S/N 15066060 N3362JLivingston Rod W · Tuttle, NDBuilt 1967 · S/N 15066062

Back to AD 2009-10-09 R2