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.
N7236PMark A Smith Aircraft Sales Inc · Homosassa, FLN7236QTeren Nelson F · Friday Harbor, WAN7237DBobinchak Richard G · Sheridan, WYN7237GIvoprop Corp · Long Beach, CAN7237QMartin Bach Aviation LLC · Cornelius, NCN7237WPetropulos James J · Juneau, AKN72383Niagarawings Aviation LLC · Niagara Falls, NYN7238FDoll William J · Carlisle, PAN7238LHorizon Flight Center LLC · Chesapeake, VAN7238VKnutson Wayne R · Thompson, NDN7238WRupert Shon D · Greenwood, ARN7239DHaning Thomas B · Vian, OKN7239KHodgson Joel R · Palmer, AKN7239PMccabe Gregory · Melbourne Beach, FLN7239WWiza Jason · Custer, WIN723AGShortt Aircraft Leasing LLC · Wilmington, DEN723AJCavorite Aviation LLC · West Jordan, UTN723AKFrohnapfel Mark T · Cordova, AKN723CCavner Hudson A · Port Alsworth, AKN723CBPrivateflyer LLC · Lewes, DEN723CFCay Air Inc · Largo, FLN723CJNicholson Scott V · Kalamazoo, MIN723CLVan Why Johnathan Ryan · Corvallis, ORN723CTN723ct LLC · Bend, ORN723GPuerta Jose Fernando Del Valle · Miami, FLN723GALong Island Aviators LLC · Seaford, NYN723JSAlbertson James M · Westville, FLN723KYCommonwealth Of Kentucky · Frankfort, KYN723LHParker Robert · Oklahoma City, OKN723MRaber Micah D · Wasilla, AKN723MLVertical Corp · Kalispell, MTN723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeN723PGPoplar Grove Airmotive Inc · Poplar Grove, ILN723PMCeu LLC · Greer, SCN723RGHatchett Creek Leasing Inc · Delta, ALN723RVSmith Stuart T · Murrieta, CAN723SSmaltz David I · Newmanstown, PAN724Morrison Richard L Trustee · Anchorage, AKN72400Brown Michael · Greeneville, TNFirst renewal noticeN72403Drury Edward D · Little Silver, NJN7240FDewberry Dylan C · Springfield, ORN7240GKendallville Flying Club Inc · Auburn, INN7240JFlytt LLC · Naples, FLN7240YHodges David S · Reidsville, GAN7241CHeritage Timothy D · Glendale, AZN7241DFrisby James A · Palmer, AKN7241JHopkins Justin C · Benson, AZFirst renewal noticeN7241WBurtchett Tyler D · Buckeye, AZN72421N83882 Inc · Huntington, NYN72424Magill William J · Moncks Corner, SC
Back to AD 87-10-06 R1