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.

N8892GMcnamee Paul J · Roseville, MNS/N 15062992 N8892UPropbusters Flying Club Inc · Wintersville, OHBuilt 1976 · S/N 15078014 N8893GTurner Timothy D · Bonneau, SCBuilt 1966 · S/N 15062993 N8894SArmstrong Richard R · Port Crane, NYBuilt 1965 · S/N 15062194 N8894UMeyer Larry F · Brush, COBuilt 1976 · S/N 15078015 N8895SSyverson Kylie E · Prescott, WIBuilt 1966 · S/N 15062195 N8896SWombles Earnest · Knoxville, TNBuilt 1965 · S/N 15062196 N8897GShore Gerry · Inez, TXBuilt 1966 · S/N 15062997 N8897STutak Peter B · Indianapolis, INFirst renewal noticeS/N 15062197 N8897URobison Stephen K · Frederick, MDBuilt 1976 · S/N 15078018 N88GMField Drew H · Dallas, TXBuilt 1972 · S/N 150-73318 N88HSShields Edwin G · York, SCBuilt 1968 · S/N 15069271 N88KNRegistration Pending · Santa Rosa, CARegistration pendingBuilt 1966 · S/N 15065181 N88YWCharlston Michael M · Haleiwa, HIS/N 15283335 N89021Tevik Michael A · Provo, UTBuilt 1978 · S/N 15282598 N89038Gross Matthew D · Saint Paul, MNFirst renewal noticeBuilt 1978 · S/N 15282606 N89054Stcup 152 LLC · Chicago, ILBuilt 1978 · S/N 15282611 N89055Hageman George · Pebble Beach, CABuilt 1978 · S/N 15282612 N8906SHoskins Brent E · Caldwell, IDBuilt 1965 · S/N 15062206 N89071Pavco Inc · Gig Harbor, WABuilt 1978 · S/N 15282617 N89073O Reilly Thomas P · Oscoda, MIBuilt 1978 · S/N 15282618 N89090Huggins Elissa D · El Paso, TXBuilt 1978 · S/N 15282626 N89098Dobbelaere Craig · Oakwood, OHBuilt 1978 · S/N 15282630 N89114Drop Table Airplanes LLC · San Anselmo, CABuilt 1978 · S/N 15282638 N8911SPriglmeier Mark L · Deerwood, MNBuilt 1965 · S/N 15062211 N89132Affiliated Air Services Inc · Southampton, NJBuilt 1978 · S/N 15282642 N8914SCarroll Louis · Perris, CABuilt 1965 · S/N 15062214 N89159Napiecek Sarah · Kyle, TXBuilt 1978 · S/N 15282654 N89186Hangar 47 Aviation LLC · Midvale, UTBuilt 1978 · S/N 15282665 N89192Stone Christopher B · High Point, NCBuilt 1978 · S/N 15282668 N89197Campbell Michael R · Aurora, NES/N 15282670 N8920SWefald Richard I · Jordan, MNBuilt 1965 · S/N 15062220 N89215Delgado Ruben E · San Antonio, TXBuilt 1978 · S/N 15282676 N89226Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282682 N8923SHuang Chen · Chino Hills, CABuilt 1965 · S/N 15062223 N8926SRichardson Gordon P · Polson, MTBuilt 1965 · S/N 15062226 N89273Anderson Ben H · Fort Smith, ARBuilt 1978 · S/N 15282697 N8927URoberts Colton C · Bluebell, UTS/N 15078022 N8928SFaith Flight LLC · Hopkinsville, KYBuilt 1965 · S/N 15062228 N8929UKrushinski Joseph M · Stafford, VABuilt 1976 · S/N 15078023 N892HAInternational Air Services Inc Trustee · Carson City, NVS/N F150-0312 N893012265 LLC · Mercer Island, WABuilt 1978 · S/N 15282706 N89310Kuyl Marinus D · Forest Grove, ORBuilt 1978 · S/N 15282708 N89312Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282710 N89333Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1978 · S/N 15282717 N8933SHempy David B · Lexington, KYBuilt 1965 · S/N 15062233 N89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 15282724 N89359Mccartney Robert · Mountain View, CABuilt 1978 · S/N 15282725 N8935SRegistration Pending · Mesa, AZRegistration pendingS/N 15062235 N8936SWings Over Texas Holdings LLC · Denton, TXBuilt 1965 · S/N 15062236

Back to AD 2009-10-09 R2