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.

N65415Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281537 N65417Frear Robert · N Redngtn Bch, FLBuilt 1978 · S/N 15281539 N6541SBurke Frank E Jr · Scotland, SDBuilt 1967 · S/N 15067341 N65435Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281550 N65439Pnl Aero LLC · Raleigh, NCBuilt 1981 · S/N 15285287 N6543FJackson Road Flyers · Wayne, MIS/N 15063143 N65440G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281554 N65449Hoeft Cliff A · Pilot Rock, ORBuilt 1978 · S/N 15281557 N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045 N65468Burger John J · Ocala, FLBuilt 1978 · S/N 15281569 N65470Jt Aero LLC · Wilmington, DEBuilt 1978 · S/N 15281570 N6547GLarson Jerry L Jr · Shelby, MTBuilt 1970 · S/N 15072047 N6547SMiller Bradley J · Joliet, MTS/N 15067347 N65483American Aviation Inc · Brooksville, FLS/N 15281580 N6548GRoeder Paul A · Waukon, IABuilt 1970 · S/N 15072048 N6548SDersch Jonathan D · Mullica Hill, NJBuilt 1967 · S/N 15067348 N65495Circle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 15281587 N65498Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281588 N6549GAviaschin LLC · Frisco, TXBuilt 1970 · S/N 15072049 N65506Skelton James P Jr · Lithia Springs, GABuilt 1978 · S/N 15281593 N6552BHollenberg Randall W · Houston, TXBuilt 1979 · S/N 15283948 N6553SRegistration Pending · Coeur D Alene, IDRegistration pendingBuilt 1967 · S/N 15067353 N65546Baas Holdings LLC · Lewes, DES/N 15281608 N6554FMendonca Jimmy · Caddo Mills, TXBuilt 1966 · S/N 15063154 N6554GAll Bid Inc · Opelousas, LAS/N 15072054 N6554LN6554l LLC · Cheyenne, WYBuilt 1980 · S/N 15284432 N65550Haltom Gary D · Alva, OKBuilt 1978 · S/N 15281612 N65551Riverside Flight Center Inc · Tulsa, OKBuilt 1978 · S/N 15281613 N6555FThompson Jeffrey L · Scandia, KSS/N 15063155 N65561Wisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 15281619 N65563Darcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 15281621 N6556GBurnett Gregory D · Union, KYBuilt 1970 · S/N 15072056 N6556SPflederer Raymond F · Sturgeon Bay, WIBuilt 1967 · S/N 15067356 N65572Rucinski Edward A · Climax, NCS/N 15281626 N65582Curley Keron P · Rockaway Park, NYBuilt 1978 · S/N 15281632 N65583Meridian Airport Authority · Meridian, MSBuilt 1978 · S/N 15281633 N65584G And M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281634 N65586Sunstate Aviation Inc · Kissimmee, FLBuilt 1978 · S/N 15281636 N6558FMolek Jon · Warren, OHS/N 15063158 N6558SVan Bavel Ethan G · Soldotna, AKBuilt 1967 · S/N 15067358 N65592Cohen Frederick I Trustee · Tulsa, OKBuilt 1978 · S/N 15281639 N6559SReichelt Harvey R · Ossian, INBuilt 1967 · S/N 15067359 N65609Leland Robert · Ft Wayne, INBuilt 1978 · S/N 15281648 N6560SClemons Mark T · Bullhead City, AZBuilt 1967 · S/N 15067360 N65610Flying Vikings Inc · Hayward, CABuilt 1978 · S/N 15281649 N65613Christiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 15281652 N65619Registration Pending · Long Beach, CARegistration pendingBuilt 1978 · S/N 15281655 N6561FWings Aero LLC · Zeeland, MIBuilt 1966 · S/N 15063161 N6561GDave Faust Inc · Wellington, KSBuilt 1970 · S/N 15072061 N6561LCentral Mississippi Aircraft LLC · Hickory, MSBuilt 1980 · S/N 15284437

Back to AD 2009-10-09 R2