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.
N724HRHeller Martin Bruce · Southport, NCN724JMTygielski Brent R · Clarkston, MIN724LPBone Aviation LLC · Calhoun, GAN724RStardust Aviation LLC · Farmingdale, NYN724RBBourgeois J Rion · Canby, ORN724RCCavanaugh Air LLC · Addison, TXN724RGHeli Guide Leasing Inc · Crystal Beach, FLN724RVPham Brian T · Long Beach, CAN724TMiller Neil · Plymouth, MNN724TMMorcom Aviation Services Inc DBA · Everett, WAN724TXStratus Aviation LLC DBA · Vacaville, CAN724VSTwin Oaks L & A Ltd · Wilmington, DEN724WRichard A Klie · Edwardsville, ILN724XGuerra Ricardo Jr · Plano, TXN7250DTrump Roger L · Greenville, OHN7250JBrandenburg Carl A Jr · Goodyear, AZN7250PTrayer Kevin B Trustee · Haslet, TXN7250QSale Reported · Crystal, MNSale reported, pending cancellationN7250WHuber Peter Michael · Pulaski, VAN7251FWright Charles W · Selbyville, DEN7251JChapman Michael S · Cardington, OHN7251QGarcia Crystal M · Brownsville, ORN7252GLeaders Flying Service LLC · Clear Lake, MNN7252JMedina Jose · Spring, TXN7252PSchaefer Hugh W · Merrick, NYN7252QRobbins Aviation LLC · Scottsbluff, NEN7252SDorris Joseph · Lewisburg, KYN7252YGuyer James · Billings, MTN7252ZAerial Banners Inc · Pembroke Pines, FLN7253GOne Mile LLC · Canton, GAN7253JLeffler William J · Tucson, AZN7253QHarry'S Hawks · Wells, MNN7253WGross Matthew A · Ridgecrest, CAN7253YJednacz Scott T · Bixby, OKFirst renewal noticeN7254FWolf Kim A · East Wenatchee, WAN7254JMinkel Chad A · Chanhassen, MNN7254QRegistration Pending · Phoenix, AZRegistration pendingN7254WMonroe County Flyers And Sales LLC · Sweetwater, TNN7254YSpldkd LLC · New Richmond, WIN72551Gonzalez Christian · Manati, PRN72553Whittom Ron W Jr · Wasilla, AKN72559Welch Paul · Oldsmar, FLN7255FN7255f LLC · Cedar City, UTN7255JRury Bryan · Midlothian, TXN7255PKubik Rodrick D · Waukee, IAFirst renewal noticeN7255QSierra Sky Aviation LLC · Kalispell, MTN7255ZCentral Ms Soaring Society LLC · Brandon, MSN7256DAir Supremacy LLC · Bend, ORN7256FZihala William · North Little Rock, ARN7256GAvstar Inc · Seattle, WA
Back to AD 87-10-06 R1