AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N125VSMcfarland Joel E · Pittsford, NYN125WB90er LLC · Wilmington, DEN125WEOhio State University · Columbus, OHN125WWRegistered aircraftN125WYNorthstar Aerospray Inc · Clara City, MNN125YDsr-Cherokee 180 LLC · Dallas, TXFirst renewal noticeN1260JHillhouse Mark S · Angie, LAN1260KChristiansen Aviation LLC · Wilmington, DEN1260XCross Paul D · Cowan, TNN1261Evy Holdings Inc · White Marsh, MDN1261BClark Robert J · Brookshire, TXN1261TObrien Timothy D · Alplaus, NYN1262JMendez Leo Jr · Corpus Christi, TXN1262XHawley Christopher M · Chandler, AZN12648Aircraft Trade Group LLC · Scandia, MNN1264XAnderson Kyle S · Portland, ORN1268JSiers Laurie A · Boardman, OHN1269CNovember 1269 Charlie LLC · East Montpelier, VTN1269TCheek Joey F · Red Bluff, CAN126AAAmerican Aviation Inc · Brooksville, FLN126AVN106ka LLC · Manassas, VAN126BBG & M Aviation LLC · Kokomo, INN126BSCape Island Aviation LLC · Millville, NJN126CAFeltmann Dean A · North Charleston, SCN126CMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN126DRForbis Michael · Calera, OKN126HJPeterson Charles William · Midway City, CAN126JBElam Jon L · Trinity, ALN126LMMatt Aviation Propertis Inc · Nashua, NHN126MLL3 Cts Airline Academy · Sanford, FLN126PCRoots & Wings Aviation LLC · West Simsbury, CTN126PKPtk Equipment Inc · Miami Lakes, FLN126RGPetersen Alfred Charles · Buffalo Grove, ILN126SCDriven Design Studio Pllc · Battle Creek, MIN126SPPilling Stephen · Southport, NCN126VAHuber Airpark Civic Club LLC · Seguin, TXN126VUAmir Aviation LLC · Saint Petersburg, FLN126WBFlying Blank LLC · La Crosse, WIN1270JWendell Matthew D · Telford, PAN1270KChristiansen Aviation LLC · Wilmington, DEN1270TTubman Wilbur C · Grand Rapids, MIN1270XFox Aviation Holdings LLC · Leesburg, INN1271JSimmons Marcus M · Glen Allen, VAN1272TMyers Brent A · Palm Bay, FLN1272XUrban Norman A · Ray, MIN1274JWorbey Philip Colin · Melbourne, FLN1275BWeisgram Ted · Corbett, ORN1275JEllis Keith W · Springfield, MON1275RHatter Dan D · Dumas, TXN12767Lipstreu William H · Hudson, OH
Back to AD 2006-10-21