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.
N639STVector Aviation LLC · Mentor, OHN639TBMurphy Craig D · Boise, IDN63ACurry Vertis Michael · Crockett, TXN63ABAircraft Leasing & Management LLC · Lewes, DEN63AJSehgal Aviation Inc · Shoreline, WAN63AKWinchell Lawrence R III · Salem, NJN63AMSierra Yankee Victor LLC · Austin, TXN63AZArnold Vincent Craig · Rosharon, TXN63BASullivan Richard P · Star, IDN63BDCampbell Joseph H · Jeffersonville, INN63BESutton John S · Pelham, ALN63BGDenali Asset Management LLC · Incline Village, NVN63BSPfinx LLC · Chapel Hill, NCN63BTSilverback Solutions LLC · Amlin, OHN63CEBarr Air Patrol LLC · Mesquite, TXFirst renewal noticeN63CLThomas Matthew L · Lakeland, FLN63CTSmith Glenn C · University Place, WAN63CVClark Terry L · Bartlesville, OKN63DABass Lake Aviation LLC · Webster, WIN63DGMiller Colette L · Sequim, WAN63DMDurbin Hal E · Findlay, OHN63DTTanona Duane T · Enumclaw, WAN63EDRosinbaum Daryl A · Waller, TXN63EZWorley Dan L · Heber Springs, ARN63FEFour Macs Logistics LLC · Houlka, MSN63FHRegistered aircraftN63FKHawley Robert W · Fort Worth, TXN63FM63 Foxmike Inc · Wilmington, DEN63GOneil Liam Trustee · Vashon, WAN63GKRawareo LLC · Warsaw, MON63GMBmi Aviation LLC · Hallandale Beach, FLN63GSAerial Surveys Inc · Dover, DEN63HESkoog Rodney D · White Bear Lake, MNN63HYTailwheel Pilots LLC · Lacon, ILN63JDD'Angelo Joseph P · Callicoon Center, NYN63JWRegistered aircraftN63KBBeene Kenneth E · Waco, TXN63LDKnudsen Allan L · Council Bluffs, IAN63LTEtienne Realty LLC · Pembroke Pines, FLN63LUChristiansen Aviation LLC · Wilmington, DEN63MMNzere Michael · Crowley, TXN63MSSire Daniel T · Wausau, WIN63MTGriffith Gary L · Palestine, TXN63PEGoodinson Marc D · Hamburg, NJN63PKRegistered aircraftN63PLBoeing Employees Flying Club St Louis Inc · Saint Louis, MON63PVAir Tech Flying Club Inc · Chesterfield, VAN63RMclenaghan Alvin N · Phoenix, AZN63RH4-D Aviation Consulting LLC · Wilmington, DEN63RLVolland Aimee C · Tavernier, FL
Back to AD 87-10-06 R1