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.
N1391TAbita Air LLC · Covington, LAN1392WSale Reported · Lakeland, FLSale reportedN13939Diessner Daniel J · New Smyrna Beach, FLN1393VWayne Brett M · Saint George, UTN1394JFendi Aviation LLC · Petal, MSN1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeN13950Bml Aviation LLC · Arvada, CON1395FMoquin Christopher · Chicago, ILN1395JWard Brian S · Long Beach, CAN1395TLegacy Aerospace Industries LLC · Miami, FLN1395WRienstra Andrew P · South Lyon, MIN13966Chesapeake Aviation LLC · Lewes, DEFirst renewal noticeN1396WD & J Solutions Inc · Nokesville, VAN13974Total Prf LLC · New Smyrna Beach, FLN1397WMorris Michael E · Las Vegas, NVN13980Aileron Buzz LLC · Daytona Beach, FLN13982Bray Aviation LLC · Calera, OKN13984Smith Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeN13986Euro 2000 Inc · Merritt Island, FLN13987Island Birds Inc · St Thomas, VIN1398CBennett Eric · Warsaw, INN1398HMiller Debra L · Anchorage, AKN1398JPrivedenynk Sergey · Springfield, MAN13998Granger Vic · Union Grove, ALN1399TLauff Samuel Jr · Ocala, FLN139ACDavis Mark A · Lubbock, TXN139BCTrombley Steven T · Worland, WYN139BKInternational Air Service Inc Trustee · Carson City, NVN139CASquires Gregory K · Cedar Park, TXN139CPLai LLC · Pearl, MSN139DBWolfe LLC · Rogers, TXN139DMMurillo Raymond A · Pico Rivera, CAN139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN139MWhitney Richard T · Steamboat Springs, CON139MTMiddle Tennessee State University · Murfreesboro, TNN139NLowery William D · Geneva, FLN139RABeach Cruisers LLC · Ormond Beach, FLN139SAMississippi Forestry Commission · Pearl, MSN139TFWithrotor Aviation Inc · Lakeview, ORN139TWMcghee James Allen · Houston, TXN139UDAb Prop Plane II LLC · Metairie, LAN139WTCotton Business Enterprises LLC · Hummelstown, PAN13AHCasady Joseph P · Buckley, WAN13ALNorthstar Holdings LLC · Anchorage, AKN13AVGrant Aviation Inc · Anchorage, AKN13BDLinenfelser Charles D · Hardy, VAN13BFWygant Steven J · Copper Center, AKN13BRC-140 Co LLC · Pensacola, FLN13BSSteele Roger H · Cedar City, UTN13CAAeroclub Management LLC · Cincinnati, OH
Back to AD 2006-10-21