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.
N115ACRuhlman Dan C · Youngsville, PAN115AKGrob Aircraft N115ak Llp · Steamboat Springs, CON115BWAllen Motor Co Inc · Star, NCN115CEDentate Equipment Leasing LLC · Belmont, MAN115CPCivil Air Patrol · Maxwell Afb, ALN115CSBurger Aviation LLC · Brandon, MSN115DCLong Jerry D · Solvang, CAN115DDDed Aviation LLC · Saint Louis, MON115DKN4471j LLC · Dover, DEN115DLJ & S Consulting Solutions LLC · Middletown, DEN115DSOverly Christopher Daniel · Williamsport, OHN115FJFargo Jet Center LLC · Fargo, NDN115GTWahl John H · Rockwell City, IAN115HPCam Aviation LLC · Valparaiso, INN115JHanson John Eric · Livermore, CAN115JDC R Aviation Inc · Miami, FLN115JEKillion Christopher Brett · Wausatosa, WIN115JRTobago4 LLC · Lawrenceville, GAN115JWFeric Drazen · Mesa, AZN115KMDoherty Sean V · Dunnigan, CAN115KSKent State University · Stow, OHN115KTMulva Jonathan · De Pere, WIN115LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeN115LWCrest Airpark Inc · Kent, WAN115MDSpecial Orthogonal Group LLC · Dover, DEN115NSprauer Constance D · Kensington, NHN115NFAnaconda Aero LLC · Anaconda, MTN115PFHigh Tech Metals Inc · Harrisburg, PAN115PMHowerton Michael J · Huntsville, ALN115RXBrazell Richard L · Jamul, CAN115SJWolf Richard · Yerington, NVN115SV115sv LLC · Lamar, MON115SZThree Greens LLC · San Jose, CAN115TAAtp Aircraft 7 LLC · Wilmington, DEN115TPCavu Enterprises · Edgerton, WIN115TWYale Companies LLC DBA · Indianapolis, INN115VSSei Vincent J · Albuquerque, NMN115WCDougherty Caroline J · Bethel, PAN115WSJorgenson Brian K · Sandpoint, IDN115XTStaley Ronald L · Lebanon, ORN11600Nolan James B · Chandler, AZN11608Aircraft Trade Group LLC · Scandia, MNN1160JSchreiber William E II · Edgar, WIN1160UPiper Aircraft Inc · Vero Beach, FLN1160XWagner Robert J · Dubuque, IAN11614Lewis University · Romeoville, ILN1161JMnd Services LLC · Joliet, ILN1161XBarnett Donald R · Atoka, TNN11625Oil Region Aviators LLC · Titusville, PAN1162CReemts Randy G · Alexandria, MN
Back to AD 2006-10-21