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.
N7561GNextgen Flight Academy Inc · Riverside, CAN7561KSumpter Carl W · Wasilla, AKN7561LBabcock Amber D · Anchorage, AKN7561PHand Nicholas P · Tahlequah, OKN7561WRay James L Jr · Meridianville, ALN7561XNri Flying Club Inc · Walnut Creek, CAN7561YStinson Aviation LLC · Middletown, DEN75620Nitta Jeffrey M · Waipahu, HIN75621Turo Ron · Mt Holly Spgs, PAN75626Fanning James F · Palm Coast, FLN7562DRiek Ronald R · Woodville, WIN7562GWings Over Texas Holdings LLC · Denton, TXN7562PMinden Aircraft Repair Inc · Minden, NVN7562RDjm Investments Inc · Menno, SDN7562YOtten John P · Lingle, WYN75633Dauphinee Kevin Carl · Bingham, MEN75635Sarge Aviation LLC · Brazoria, TXN7563FPayne Jimmy D · Newnan, GAN7563GOso Air LLC · Missoula, MTN7563JKring Neal A · Ash Flat, ARN7563RWright Barry C · Skidmore, MON75643Pecoraro Michael J · Gloucester, MAN75649New Horizons Aviation Inc · Goshen, INN7564DOtto Bryant C · Conway, ARN7564GRegistration Pending · Sterling, AKRegistration pendingN75651Hansen Robert Alan · Horseheads, NYN75655Doane Dale A · Moreland, GAN7565DSiegle Daniel L · Birdsboro, PAN7565GB&R Aircraft LLC · Wadsworth, OHN7565JSteffensen David J · Grimesland, NCN7565PWagner Chelsea Mele · Santa Cruz, CAN7565RKnox County Flying Club · Owls Head, MEN7565WHurdle Scott R · Clemmons, NCN7565XDonaldson Bros Flying Circus LLC · Spencer, IAN7565YVictor Robert W Jr · Topeka, KSN7566PLambert Dwight E · Albany, ORN7566RHill Bruce W · Newton, ILN7566WStrobel Gary D · Mooresville, NCN7566YS & D Adventure LLC · Middletown, DEN7567FMansfield Heliflight Inc · Milton, VTN7567GWhipple Eugene B · Mchenry, ILN7567JFidelis Universal Technology Inc · Chino Hills, CAN7567PSteigerwalt Jeffrey A · Lehighton, PAN7567RThomas Baley B · Zavalla, TXFirst renewal noticeN7568FTranbarger Tad E · Macksville, KSN7568JRoberts Donald B · Albion, ILN7568PBroussard James · Colmesneil, TXN7568TSale Reported · Phoenix, AZSale reportedN7568YAviation Associates LLC · Oxford, MDN7569DThiele Tamara L · Anchorage, AK
Back to AD 87-10-06 R1