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.
N2662ARogers Construction Services Inc · Boca Raton, FLN2662BGjl Aviation LLC · Fort Worth, TXN2662TPlane Aviation LLC · Camarillo, CAN2662WEaton Mark E · Houston, TXN2662ZBidcal Inc · Chico, CAN26630Iasco Flight Training Inc · Redding, CAN2663XAvolant Aviation LLC · Mooresville, NCN2664UHill Flying Club Inc · St George, UTN2665CWindsock Skies LLC · Caldwell, TXN2666TNess Ronald O · Canyon Lake, CAN2667WMartens Steven A · Stanley, NDN2667ZHite Loren E · Fairbanks, AKN2668TKing Thomas S · Boerne, TXN2668WJarchow John H · Denison, TXN2669WAlecci Alexander Drew · Sanford, FLN266AAFf22 LLC · Scottsdale, AZN266ATAirline Transport Professionals Corp Of USA · Wilmington, DEN266BBetki Randy A · Grosse Ile, MIN266BBJk Air LLC · Duncan, OKN266DHurricane Mesa Aviation LLC · Hurricane, UTN266DLCampbell Thomas J · Center, TXN266FAStratus Rr LLC · New Castle, DEN266LARaintree Aviation LLC · Mesa, AZN266MEGershman Randy · Marshfield, WIN266MGGeorgia Aviation Authority · Eastman, GAN266SFEastern Stearman Inc Trustee · Leesburg, VAN266SHDirty Bird Helicopters LLC · Boerne, TXN266SPTfs Air LLC · Loveland, CON266SWWeddle Scott M Trustee · Albany, ORN266WBBell W Douglas · Grand Haven, MIN266WYReps R1 Drive Unit Co LLC · Helena, MTN266YHogg James R · New Albany, OHN2671WSchwister Daniel Edward · Woodinville, WAN2672Q4m Aviation LLC · Orting, WAN2672THilgendorf Blake W · Fairmont, MNN2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKN2672XBird Nest Aviation LLC · Sheldon, IAN2673TZweig William D · Chesterfield, MON2673WAdolf Charles P · Ocala, FLN2674TCosgrove John W · Lake Ariel, PAN2674WHough Publishing LLC · Atlanta, GAN2675DPaige Barry Wayne · Wasilla, AKN2676TMills Nicolas A · Greenwood, NYN2677TDaggett Truck Lines Inc · Frazee, MNN2677WSaunders Charles A · Scott Depot, WVN2678TTekforce LLC · Boca Raton, FLN2678WLansford Company Inc · Lampasas, TXN267AAWings Over Texas Holdings LLC · Denton, TXN267DHInternational Air Services Inc Trustee · Carson City, NVN267GSArnold Airplane LLC · North Branch, MN
Back to AD 2006-10-21