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.

N89815Pinnacle Aviation Services Inc · Encinitas, CABuilt 1978 · S/N 15282881 N89859Hess Garrett J · Fullerton, CABuilt 1978 · S/N 15282894 N8985SOrganization Of Black Aerospace Professionals · Westchester, ILBuilt 1965 · S/N 15062285 N89863Ruess Richard M · Anchorage, AKBuilt 1978 · S/N 15282896 N89869Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282897 N8986SSchneider Jackson L · Florissant, MOBuilt 1965 · S/N 15062286 N8986UJmt Aviation LLC · Bel Air, MDBuilt 1976 · S/N 15078036 N89877Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282900 N89881Fulton Gene · Spartanburg, SCBuilt 1978 · S/N 15282903 N89887Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15282904 N8988UQuestair LLC · Madison, MSBuilt 1976 · S/N 15078038 N8992UCole Lawrence E · Willow Street, PAS/N 15078042 N89933Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282920 N89934Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282921 N8993SRopp Dale Arden · Bemidji, MNBuilt 1965 · S/N 15062293 N8994SMorel Charles Paul IV · Morgan Hill, CABuilt 1965 · S/N 15062294 N8994UWahlberg Randy A · Pearland, TXBuilt 1976 · S/N 15078044 N8995SLonneman Robert P · Edgewood, KYBuilt 1965 · S/N 15062295 N8995UKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 15078045 N89963Wardall Wesley David · Ione, CABuilt 1978 · S/N 15282931 N8996SSoaring Thunderbirds Inc · Canton, OHS/N 15062296 N8997SRed Barn Ag & Home Inc · Westville, OKBuilt 1966 · S/N 15062297 N89980Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282937 N8999SLewis Darrell K · Morehead, KYBuilt 1965 · S/N 15062299 N89HPMorgan Howard P Jr · Longmont, COBuilt 1975 · S/N 15077395 N8PWMiranda Alexander · Homestead, FLBuilt 1969 · S/N 15071312 N9000UWhitaker Robbie L · Brooklet, GABuilt 1976 · S/N 15078050 N9004RHarper Edward A · Pleasant Plain, OHS/N 15076428 N9005UPea Patch Flying Club Inc · Girard, OHBuilt 1976 · S/N 15078051 N901UBowling Robert E · Argillite, KYBuilt 1974 · S/N 15076038 N902KSSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076244 N903KSMbk Leasing And Consulting LLC · Lakeland, FLFirst renewal noticeBuilt 1975 · S/N 15076828 N903SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282468 N90432Knutson Wayne R · Thompson, NDFirst renewal noticeS/N 15070583 N9047GOdd Dale R · Aberdeen, WABuilt 1973 · S/N 15074315 N904FKJax Beach Aviation LLC · Jacksonville, FLS/N 15063706 N904WADelarosa Sergio Miguel · Miami, FLBuilt 1977 · S/N 15280291 N906AZN906az LLC · Miami, FLBuilt 1978 · S/N 15282474 N908WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281525 N909MRRipp Patrick L · Mineral Point, WIBuilt 1967 · S/N 15066219 N909SKaluahine Fredstan · Lihue, HIS/N 15280969 N90PPN90pp LLC · Titusville, FLBuilt 1973 · S/N A1500419 N9101UAura LLC · Elsie, MIBuilt 1976 · S/N 15078052 N9103UMonica Aviation LLC · Cambridge Springs, PABuilt 1976 · S/N 15078054 N9106USpafford Luke · Pontiac, ILBuilt 1976 · S/N 15078057 N9107UAnderson Christopher · Janesville, WIBuilt 1976 · S/N 15078058 N9108URegistration Pending · Studio City, CARegistration pendingBuilt 1976 · S/N 15078059 N9109UBrotherson Brian C · Independence, KYBuilt 1976 · S/N 15078060 N9111UKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N 15078062 N9112UOstrander William P · Millerton, PABuilt 1976 · S/N 15078063

Back to AD 2009-10-09 R2