AD 2002-26-01
Registered aircraft · 29,517
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
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:2002-26-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-26-01')
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:2002-26-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-26-01') 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.
N106KTDetgen Ernest J · Carmen, OKN106LValiair Lc Trustee · Casper, WYN106MRIsland Flights Inc · Wilmington, DEN106NKMenagerie Enterprises Inc DBA · Denison, TXN106PESheboygan Flying Club LLC · Sheboygan, WIN106RAChristiansen Aviation LLC · Wilmington, DEN106REColorado Aircraft Corp · Watkins, CON106RRC2 Holdings 8 LLC · Chesapeake, VAN106RVMeredith Rickey A · Lincoln, ILN106TLBurton David H · Redlands, CAN106VADeford Steven M · Livermore, CAN106VKLumion Aviation LLC · Mountain View, CAN106WKKowalewski William P · Prescott, AZN1070BCurtis Julia A · Holladay, UTN1070LWilliams Barret G · Homer, AKN1071AOcean Group LLC · Plantation, FLN1071LGrand Seaplanes LLC · Broken Arrow, OKN1071Z5280 Flying Club LLC · Castle Pines, CON1072LTorres Ramon Armando · Mulberry, FLN1072YRyan Aaron · Wichita Falls, TXN1073GProfessional Flyers Corporation · Wilmington, DEN1073LDesert Fish Aviation LLC · Queen Creek, AZN1073XAustin Arrows Inc · Austin, TXN1074CZata Group LLC · North Little Rock, ARN1074XKelley Air LLC · Milford, MIN1075LElsner Henry J · Greensboro, NCN1075MDewitt Scott C · Corpus Christi, TXFirst renewal noticeN1075NBlackstone Barry V · Superior, NEN10767Kansa Development Corporation Inc · Junction City, KSN1077EGoebel William R · Rhome, TXN1077XJny LLC · Riverview, FLN10782Kearbey Brandon · Hillsboro, ORN1078UHigh Flight Academy LLC · Allison Park, PAN10797Federal Flight LLC · Fairfax, VAN1079JElmore Danny W · Othello, WAN1079LTradewinds Aero Group LLC · Sarasota, FLN107ACBad Attitude LLC · Lisbon, OHN107AFKummer Michael · Floyd'S Knobs, INN107ALAero Tech Services Inc · Lititz, PAN107APRegistration Pending · New Braunfels, TXRegistration pendingN107AWDust Donald E · London, OHFirst renewal noticeN107BJJanowsky Bruce G · Lakewood, NYN107CKleinfelter Myles S · Lafayette, INN107ELAa-Aero LLC · Lewes, DEN107GBBarrett David A · Murrieta, CAN107GSSharp Roscoe A · Deer Park, WAN107HPMiddleton Trevor M · Cushing, OKN107JDDhall Sanjay · Canton, MIN107KPPeterman Keith A · Salinas, CAN107LJRaven Helicopter Corp · Wilmington, DE
Back to AD 2002-26-01