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.
N216WYKammann Trevor R · Wellton, AZN21705Bagamaspad Alan · Reseda, CAN21706Spinks Flight Center Inc · Burleson, TXN2170FSwaney Dustin F · Hayes, VAN2170NCottle Dennis J · Bainbridge Island, WAN2170RKotz Dennis M · North Augusta, SCN2170VB A Aeronautics LLC · Norridge, ILN2170WSacks Martin · Mill Valley, CAN21714Aero Equities LLC · Ventura, CAN21717Newton Andrew A · Mount Sterling, ILN21718Blomgren David · Phoenix, AZN2171BCleary Kevin W Trustee · Glendale, AZN2171QAmster Richard B · Brookline, MAN2171RLogan Lance P · Mc Alpin, FLN2171TBox Aviation Inc · Montgomery, ALN2171XGlobal Flight Training Solutions Inc · Immokalee, FLN2171YForbes Aviation LLC · Boise, IDN21722Western Properties Investors And Advisors LLC · Laguna Niguel, CAN21727Centennial Corp · Reno, NVN2172BBenesh Mark L · Punta Gorda, FLN2172GSecond Wind Aviation LLC · Chesapeake, VAN2172JTaylor A Pharr Esq LLC · Alexander City, ALN2172KElite Consulting Of Swfl LLC · Naples, FLN2172MPacker Bruce P Trustee · Tempe, AZN2172UWandering Wings Inc · Fort Wayne, INN2173ERiva LLC · Sioux Falls, SDN2173SSunrise Aviation Inc · Ormond Beach, FLN2173TDitatus LLC · Cornville, AZN2173UInternational Air Services Inc Trustee · Carson City, NVN2173ZTegridy Equipment Leasing LLC · Aurora, ORN21744Oatdog Aviation LLC · Atlanta, GAN21746Sky West Aviation Inc Trustee · Albuquerque, NMN2174911:11 Enterprises LLC · San German, PRN2174RTurner Ryan J · Pittsburg, TXN2174SBarakat Robert H · Rocklin, CAN2174TSmith Dustin E · Helena, ALN2174VRjr Leasing LLC · Wilmington, DEN2174WGalena Sundowner LLC · Reno, NVN2174XBennett Milton J · Gig Harbor, WAN2175ACrawford Garrett Ross · Artesia, NMN2175TFlying Partners Of Venice LLC · Port Charlotte, FLN2175UOptimus Aircraft Service Inc · Middletown, DEN2175WIndustry Machine Design & Automation Inc · Camarillo, CAN2176LBixler David L · Lake Forest Park, WAN2176STango-Alpha LLC · Saint Charles, MON2176TSteeplechase LLC · Medfield, MAN2176XKnighten Daniel · Portland, ORN21776Beebe Jerry D · Cassville, MON21778Nodak Aircraft Leasing LLC · Fargo, NDN2177CRenaissance General Restoration Contracting · Madera, CA
Back to AD 2006-10-21