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.

N6561QChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285273 N6562MLegends Airways LLC · Lakeland, FLBuilt 1980 · S/N 15284767 N6563GVito Air Inc · Wilmington, DES/N 15072063 N6563SPendley Terry · Carbon Hill, ALBuilt 1967 · S/N 15067363 N6564FBradley John · Edgewood, NMBuilt 1966 · S/N 15063164 N6565GRoberts Brian L · Shelbyville, INBuilt 1970 · S/N 15072065 N6566FOdekirk David C · Watertown, WIBuilt 1966 · S/N 15063166 N6566GHopkins Juan A · Nogales, AZBuilt 1970 · S/N 15072066 N6566PSouthwinds Export Inc · Kissimmee, FLS/N 15285034 N6568GAntler Aviation And Wildlife Service LLC · Wasilla, AKS/N 15072068 N6568SBell Daniel M · Mc Alpin, FLFirst renewal noticeBuilt 1967 · S/N 15067368 N6569FWise Joe · Kilgore, TXBuilt 1966 · S/N 15063169 N6569SSawicki Victor · Columbus, MIBuilt 1967 · S/N 15067369 N6570FMykland Bennett · Graham, WABuilt 1966 · S/N 15063170 N6570SAnderson Christopher D · Newark, OHBuilt 1967 · S/N 15067370 N6572GAero Equities LLC · Ventura, CABuilt 1970 · S/N 15072072 N6572SGlatt Nicolas · Mazama, WABuilt 1967 · S/N 15067372 N6573LBreland James · Laurel, MSS/N 15284443 N6575FBarnett Joe N · Siloam Springs, ARBuilt 1966 · S/N 15063175 N6575QRegistered aircraftBuilt 1981 · S/N 15285274 N6577QForce Gary · Granbury, TXBuilt 1981 · S/N 15285275 N6579FPratka Rhett A · Pleasanton, TXBuilt 1966 · S/N 15063179 N6580FLawson Jeremiah · Lunenburg, VTBuilt 1966 · S/N 15063180 N6580GMonskey David Paul · Minnetonka, MNBuilt 1970 · S/N 15072080 N6580LHigh Wing Air Services LLC · Merritt Island, FLBuilt 1980 · S/N 15284446 N6581GCox Martin S · Greenwood, INBuilt 1970 · S/N 15072081 N6582FHemmatyar Nabi Z · Malibu, CAS/N 15063182 N6583FButterfield Rory A · Milan, NMS/N 15063183 N6583GRusch Steven A · Sequim, WABuilt 1970 · S/N 15072083 N6585FBrouse Dan T · Magnolia, TXBuilt 1966 · S/N 15063185 N6585GPace Glen M · Columbia, MSBuilt 1970 · S/N 15072085 N6586FLunar Aviation LLC · Tahlequah, OKBuilt 1966 · S/N 15063186 N6586SMiller William H · Live Oak, FLS/N 15067386 N6587FJones Aviation Inc · Biggs, CABuilt 1966 · S/N 15063187 N6587GGilkes Simon J · Gilbert, AZBuilt 1970 · S/N 15072087 N6588GAstro Aviation Inc · Whitney Point, NYBuilt 1970 · S/N 15072088 N6589FRush Paul E · Highland, KSS/N 15063189 N6589SAdamson Paul B · Sparks, NVS/N 15067389 N6590FMapes Peter B · Oscoda, MIBuilt 1966 · S/N 15063190 N6590SCoonley Russell F · Decatur, TXBuilt 1967 · S/N 15067390 N6592QCd Aircraft LLC · Signal Hill, CABuilt 1981 · S/N 15285277 N6592SBasista Robert J · Delaware, OHS/N 15067392 N6593SMilam David N · Hannibal, MOBuilt 1967 · S/N 15067393 N6594GKabat Orville · Rudyard, MIBuilt 1970 · S/N 15072094 N6595FRose Edward · Brooklyn, NYBuilt 1966 · S/N 15063195 N6595SGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1967 · S/N 15067395 N65965Legends Air Center LLC · Bentonville, ARBuilt 1978 · S/N 15281658 N6596FTrenholm Daniel L · Eagan, MNBuilt 1966 · S/N 15063196 N6596PAce Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 15285036 N65978Freeland Christopher G · Brownwood, TXS/N 15075753

Back to AD 2009-10-09 R2