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.

N9391UKnight Services And Consulting LLC · Dardanelle, ARS/N 15078339 N93927Williams Michael T · Leo, INBuilt 1982 · S/N 15285574 N9392USale Reported · Wheeling, ILSale reportedBuilt 1976 · S/N 15078340 N9394UYu Hermon Lemuel C · Mays Landing, NJBuilt 1976 · S/N 15078342 N9396AFortune Michael W · East Dublin, GABuilt 1976 · S/N 150-78550 N9396UMullen Randy R · Pasco, WAS/N 15078344 N9397UWelch Kerry D · Alpine, UTS/N 15078345 N93980Pruitt Hugh A · Ardmore, OKBuilt 1982 · S/N 15285579 N93989Sunrise Aviation Inc · Ormond Beach, FLBuilt 1982 · S/N 15285580 N9398UShouling & Philip Enterprise · Lancaster, CABuilt 1976 · S/N 15078346 N939ACFlorida Flight Training Center Inc · Venice, FLBuilt 1982 · S/N 15285612 N94006Leading Edge Aviation Inc · Doylestown, PAFirst renewal noticeBuilt 1982 · S/N 15285582 N9402UMayrant Dawson Z · College Station, TXS/N 15078350 N9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeBuilt 1976 · S/N 15078351 N9404UWhitcomb James F · West Ossipee, NHBuilt 1976 · S/N 15078352 N9405UBishop Michael E · Clarkston, WAS/N 15078353 N9406UMontgomery Paul Richard · Fredericksburg, VABuilt 1976 · S/N 15078354 N9408UTenhoff Lee L · Homer, AKBuilt 1976 · S/N 15078356 N94097Registration Pending · St Simons Island, GARegistration pendingBuilt 1982 · S/N 15285595 N9409UFree Wade · Sharon, OKBuilt 1976 · S/N 15078357 N940RJLaguna Verde Leasing Inc · Wilmington, DEBuilt 1978 · S/N 15281680 N94112Cooper Robert Jb · Wichita, KSBuilt 1982 · S/N 15285600 N94118Unique Educational Experiences · Long Beach, CABuilt 1982 · S/N 15285601 N9412UGoshev Daniel Mihaylov · Gaithersburg, MDBuilt 1976 · S/N 15078360 N94138Space Coast Aircraft Co · Merritt Island, FLBuilt 1982 · S/N 15285606 N94140Ng Calvin · Houston, TXBuilt 1982 · S/N 15285607 N94179Aerophile LLC · Wilmington, DEBuilt 1982 · S/N 15285613 N9418UAftcloud Inc · Ontario, CABuilt 1976 · S/N 15078366 N94194Power Flow Systems Inc · Daytona Beach, FLBuilt 1982 · S/N 15285618 N9420USouthquarter Aviation LLC · Youngstown, OHBuilt 1976 · S/N 15078368 N9422UHortman Ryan Davis · Summerville, SCBuilt 1976 · S/N 15078370 N94247Solberg Aviation Co Inc · Whitehouse Station, NJBuilt 1982 · S/N 15285630 N94270N94270 LLC · Chesterfield, NJBuilt 1982 · S/N 15285634 N94286Purdue Aviation LLC · West Lafayette, INBuilt 1982 · S/N 15285639 N94292My Way Aviation LLC · Weston, FLBuilt 1982 · S/N 15285643 N9429UTangleport LLC · Amarillo, TXBuilt 1976 · S/N 15078377 N942XAClymer Jordan · Cape Canaveral, FLS/N 15070510 N9430MKruschwitz David A · Anchorage, AKBuilt 1974 · S/N 15075669 N9437UAom Aircraft LLC · Wilmington, DES/N 15078385 N94397Koenitzer Judson B · Chetek, WIBuilt 1982 · S/N 15285662 N9439URautiola Patricia H · Rosemount, MNS/N 15078387 N943SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279675 N94400Macinnis James Michael · Copley, OHBuilt 1982 · S/N 15285663 N94401Maui Aviators LLC · Pukalani, HIBuilt 1982 · S/N 15285664 N9440USmith Peter I Trustee · Ocala, FLS/N 15078388 N9441ULewis Paul A · Spring, TXBuilt 1976 · S/N 15078389 N94429Wisconsin Aviation Inc · Watertown, WIBuilt 1982 · S/N 15285669 N94447Flightime LLC · Stuyvesant, NYBuilt 1982 · S/N 15285673 N9444UB2w Corporation · Winona, MNBuilt 1976 · S/N 15078392 N9446UTepper Jesse J · New York, NYBuilt 1976 · S/N 15078394

Back to AD 2009-10-09 R2