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.
N2281SHyce Richard A · Wasilla, AKN2281TAvpac Insurance Services Inc · Santa Ana, CAN2284TKenley Clay · Crockett, TXN2284UAttitude Toys LLC · Wilmington, DEN2287AGiacopassi Dean · Newport News, VAN2288FJ&Jn2288 LLC · Houston, TXN2288QMidnight 30 LLC · Columbia, MSN2288TRegistered aircraftN2288ULay Jerry K · Minonk, ILN2288ZMaxwell Robert H Jr · Quincy, FLN2289UEastern Stearman Inc Trustee · Leesburg, VAN228AMSky West Aviation Inc Trustee · Albuquerque, NMN228CABowles Thomas J · Prairie Village, KSN228CMKittleson Allen F · Granbury, TXN228ERRoscioli Lamberto · Lighthouse Point, FLN228FPRegistered aircraftN228GHopkins Boone K · Saint Simons Is, GAN228GGAircraft Guaranty Corp Trustee · Oklahoma City, OKN228HPLance Reid Enterprises LLC · Turlock, CAN228HSSweeney David H · Houston, TXN228JPMazel Wings LLC · Camden, DEN228KHSkyceci LLC · Comelius, NCN228MGGeorgia Aviation Authority · Eastman, GAN228NCIal Corp · Lewes, DEN228QRMeridian Aircraft LLC · Wilmington, DEN228SGCarver Gordon W · Wray, GAN228SHHayden Daniel · North Pole, AKN228TWNorth Delta Aviation LLC · Blytheville, ARN228UVMeridian Aircraft LLC · Wilmington, DEN228WTHowland James · Grantsville, UTN22904Phoenix East Aviation LLC · Daytona Beach, FLN2290AOrtega Aviation Services LLC · Wichita, KSN2290NKalika Kelly · Collinsville, ILN2290TKnobloch Eric D · Green Cove Springs, FLFirst renewal noticeN2290UVan Surdam John R · Seneca, SCN2291CForty Four Fifteen LLC · Reno, NVN2291UHines Scott C · Fort Worth, TXN2292MShymkewich Dale G · Arlington, VAN2293MFines Aviation #1 LLC · Fargo, NDN2294QSouth Florida Helicopters Inc · Indiantown, FLN2294RSeeliger Jeremy E · Pasco, WAN22952Winging It LLC · Lindon, UTN2296NMacsdea LLC · Van Nuys, CAN2296QKhawly Pablo Nickolai · Miramar, FLN2296TRegistered aircraftN2297MHunter Stokes & Associates LLC · Douglasville, GAN2297QFact Ware Inc · Newtown, PAN2297SRocketjet LLC · Incline Village, NVN2298MLeft Seat Flyers LLC · Mount Pleasant, SCN2298TT C Rocket LLC · Traverse City, MI
Back to AD 2006-10-21