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.

N45663Williams Kaylee A · Grapevine, TXBuilt 1975 · S/N 15077013 N45673Theimer Ryan D · West Bend, WIS/N 15077015 N4568FWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282989 N45693Wingnut Aviation LLC · Johnson City, TNBuilt 1975 · S/N 15077022 N45699Jej Leasing LLC · Bangor, MEBuilt 1975 · S/N 15077025 N456WDMinton Mark D · Mobile, ALBuilt 1973 · S/N 15075169 N45700Fritsch Raymond H · Galesville, WIBuilt 1975 · S/N 15077026 N45705Shaikh Khizer · Lake Havasu City, AZBuilt 1975 · S/N 15077027 N45714Brumagin James R · Tulalip, WABuilt 1975 · S/N 15077032 N45720Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 15077035 N457AESahni Irvin K · Seguin, TXBuilt 1967 · S/N 15066592 N4590BFulltron Aviation LLC · Springfield, MOBuilt 1979 · S/N 15283545 N4590PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284774 N45915Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 15282943 N45928Cohan Thomas A · Sparks, NVBuilt 1978 · S/N 15282945 N45941G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15282952 N45945Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15282954 N4596AMlfco LLC · Wilmington, DEBuilt 1978 · S/N A1520837 N4596PClements Willie E · Pembroke, GABuilt 1980 · S/N 15284776 N4597RSanta Cruz Airplane LLC · Santa Cruz, CABuilt 1969 · S/N 15070525 N4598QAbanks Leasing Ltd · Wilmington, DES/N 15285040 N459STMeyers Sean · Jupiter, FLBuilt 1973 · S/N 15074495 N45FASilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284757 N4600XTwo Dot Aircraft LLC · Kalispell, MTBuilt 1966 · S/N 15064650 N4601XMast Aviation LLC · South Boston, VABuilt 1966 · S/N 15064651 N46020Registration Pending · Brooksville, FLRegistration pendingBuilt 1978 · S/N 15282984 N46021152 4 Fun LLC · Gilbert, SCBuilt 1978 · S/N 15282985 N46034Employment Services Inc · Virginia Beach, VABuilt 1978 · S/N 15282986 N4606XThird Coast Aircraft LLC · Mobile, ALBuilt 1966 · S/N 15064656 N46075Perspective Aviation LLC · Comer, GABuilt 1978 · S/N 15282995 N4607XVeldhuizen Richard B · Jesup, GABuilt 1966 · S/N 15064657 N46080Sentinel Services Group LLC · Brooksville, FLBuilt 1978 · S/N 15282227 N46090Sentinel Services Group LLC · Brooksville, FLBuilt 1981 · S/N 15285318 N4609LStork 1 LLC · Green Cove Springs, FLBuilt 1980 · S/N 15284197 N46134Training Planes LLC · Tampa, FLBuilt 1978 · S/N 15283003 N46135Mc Masters James I · Springfield, VABuilt 1978 · S/N 15283004 N46138Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283005 N46146Skylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15283007 N4614BUniversity Of Michigan Flyers · Ann Arbor, MIBuilt 1979 · S/N 15283552 N4614XEdwards Dustin M · Marion, ILBuilt 1966 · S/N 15064664 N4616XDumanian Bruce C · Savannah, NYBuilt 1966 · S/N 15064666 N4618PLaguna Verde Leasing Inc · Wilmington, DES/N 15284783 N4618XEnochs Richard L · Hartford, INBuilt 1966 · S/N 15064668 N461TCFlorida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 15283103 N4620XWilliams David R · Havre, MTS/N 15064670 N4621XWidby David A · Anchorage, AKBuilt 1966 · S/N 15064671 N46249Hyldburg Aviation Inc · Plymouth, MABuilt 1978 · S/N 15283019 N46259Cobra Cavalier LLC · Mooresville, NCBuilt 1978 · S/N 15283022 N46261Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283024 N46275D Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 15283027

Back to AD 2009-10-09 R2