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.

N8494GReynolds Terry J · Phoenix, AZBuilt 1965 · S/N 15062594 N8494URieck Brian M · Junction, TXBuilt 1976 · S/N 15077940 N8495GCorrigan John P · Denver, COBuilt 1965 · S/N 15062595 N8495JParks Ryan Alan · Newcastle, WYBuilt 1967 · S/N 15066395 N8497GDeacon Jeffrey A · Battle Ground, WABuilt 1965 · S/N 15062597 N8497MWenatchee Valley Barnstormers LLC · Wenatchee, WABuilt 1970 · S/N A1500197 N8499GRyan Richard E · Atlantic, IABuilt 1965 · S/N 15062599 N84MKNew Horizons Aviation Inc · Goshen, INBuilt 1977 · S/N 15281230 N8500GAugust Mark C · Atchison, KSBuilt 1965 · S/N 15062600 N8500JRiley Alfred E III · Norristown, PABuilt 1967 · S/N 15066400 N8503GPynn David W · Gasport, NYBuilt 1965 · S/N 15062603 N8503UCropley Alton I · Sitka, AKS/N 15077941 N8505JKunz Isaac A · Texarkana, TXBuilt 1967 · S/N 15066405 N8506GNighthawk Air Systems Inc · Miami, FLS/N 15062606 N8506JHorning Richard H · Galion, OHS/N 15066406 N8507GCaldera Michael E · Williamsport, PABuilt 1965 · S/N 15062607 N8508JJanssen Willis W · Ault, COBuilt 1967 · S/N 15066408 N8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXBuilt 1965 · S/N 15062609 N850DRMooers Michael T · Haggerstown, MDBuilt 1977 · S/N 15079358 N8513JHurd Billy R · North Pole, AKBuilt 1967 · S/N 15066413 N8518GDouble Rr Holdings LLC · Dallas, TXBuilt 1965 · S/N 15062618 N8519GSullivan Aviation Maintenance LLC · Fayetteville, NCS/N 15062619 N8522JValley Jacob A · Brewer, MEBuilt 1967 · S/N 15066422 N8523GStephany Peter T · Umatilla, FLS/N 15062623 N8525JBicknell Hilary E · Warwick, RIS/N 15066425 N8526GLong Sean · Germantown, TNBuilt 1966 · S/N 15062626 N8527GAcosta Alfredo · Yuma, AZBuilt 1965 · S/N 15062627 N8528GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062628 N8528UKanning Brandon A · Graham, WABuilt 1976 · S/N 15077943 N8529JBrucks Mark D · Peachtree City, GABuilt 1967 · S/N 15066429 N8531JCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 15066431 N8532JWerner Felix A · Picayune, MSBuilt 1967 · S/N 15066432 N8534GBennett Julie L · Titusville, FLBuilt 1965 · S/N 15062634 N8535GSpeedbird Aviation One LLC · Glenn Heights, TXBuilt 1965 · S/N 15062635 N8536GMarcu David · Killen, ALS/N 15062636 N8536UIndigo Of South Fl Inc · Sunrise, FLBuilt 1976 · S/N 15077944 N8537GNugent David R · Jensen Beach, FLBuilt 1965 · S/N 15062637 N8540JSale Reported · Lamar, COSale reportedBuilt 1967 · S/N 15066440 N8541GDeseh Sarah · San Diego, CABuilt 1965 · S/N 15062641 N8542JMcdowell Donald L · Geneva, OHBuilt 1967 · S/N 15066442 N8545UNott Mike · Huntington Beach, CABuilt 1976 · S/N 15077946 N8547JL&R Consulting LLC · Las Vegas, NVBuilt 1967 · S/N 15066447 N854AJLowe David · Sacramento, KYS/N 15065832 N854KMSparrowhawk Aviation LLC · Hollister, CABuilt 1978 · S/N 15282977 N8553JMindy Limited LLC · Muscatine, IABuilt 1967 · S/N 15066453 N8555JBauer Walter G · Neenah, WIBuilt 1967 · S/N 15066455 N8557GDoddi Vikram · Austin, TXBuilt 1965 · S/N 15062657 N8557JRobertson Billy J Trustee · Cleveland, OKBuilt 1967 · S/N 15066457 N8559GAeronautical Technical Service Inc · Collierville, TNS/N 15062659 N855JWButterfield Rory A · Milan, NMS/N 15071147

Back to AD 2009-10-09 R2