AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N75242M&M Air LLC · Watkinsville, GAN75247G W R LLC · Wilmington, DEN75248Leydsman Wayne · Provo, UTN75249Steinle Michael · Smithville, NJN7524DGreene Robert M · Limestone, TNN7524FRobinson Robert L Jr · Homer, AKN7524GBrandywine Sky Ramblers LLC · West Chester, PAN7524RTiny Tin Aviation LLC · Groveland, FLN7524WN7524w LLC · Grand Ledge, MIN75252Homesky Johnathan Edward · Mcgregor, TXN75254Meyer Larry · Brush, CON75255Jackson Christopher · Clearwater, FLN7525DRedhanded LLC · Dover, DEN7525JFosdick Trevor · Aldie, VAN7525PStack Robert J · Aurora, CON7525RCallis Merle F · Lone Grove, OKN75267Avian Aerospace LLC · Mansfield, OHN75269Smart James Tim · Spurger, TXN7526DShevock Frank C Jr · Sidman, PAN7526FMikulich Joseph · Bovey, MNN7526GFoothill Aircraft Sales & Service Inc · Upland, CAN7526JWings Over Texas Holdings LLC · Denton, TXN7526LPcm Aviation LLC · Wilmington, DEN7526PSpitzer Helicopter LLC · Woodland Hills, CAN7526WWensel Tyler · North Dinwiddie, VAN75270Long Island Aviators LLC · Seaford, NYN75274Ascent Aviation Inc · Van Nuys, CAN75276Southern Aircraft Consultancy Inc Trustee · Casper, WYN75277Columbus Paul S · Laguna Beach, CAN75278Jmo Aviation LLC · Oakland, CAN75279Workman Randy C · Bells, TXN7527FProtsman Bryan D · Anchorage, AKN7527GBatista Caleb · Danese, WVN7527JOlivia Lawrence J · Memphis, NYN7527LChop Air LLC · Natchez, MSN7527PWhite Andrew D · Covelo, CAN7527RTimms Paul E · Collierville, TNN7527WKern David H · Mulberry, FLN7528FRausch Bruce Thomas · Marysville, OHN7528GSale Reported · Rillito, AZSale reported, pending cancellationN7528JKlevorn Edward D · Lake Saint Louis, MON7528LThompson Helicopters LLC · Uvalde, TXN7528PGrizzly Skins Of Alaska Inc · King Salmon, AKN7528RLange Kyle W · Mertzon, TXN7528SDoran Jeff T · Westerville, OHN7528UAg Ranch Services LLC · Lewistown, MTN7528WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7528YSkyward Solutions Inc · Lewes, DEN7528ZCastor Aviation Ltd · Ketchikan, AKN75290Barfield Daniel Malcolm · Cartersville, GA
Back to AD 87-10-06 R1