AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N9256BDillard Wendell Hoyt · Centerville, TXN92570Becker Steven H · Prescott, AZN9257HTaf Aerial Services LLC · Beeville, TXN9257ULiberty Flyers Inc · Ramsey, MNN92584Buckner Walter · Columbia, TNN9258GHerb Meloche Ltd · West Allis, WIN92593Snider Scott E DBA · Turner, MTN92595Bearfight Aviation LLC · Dover, DEN92597Morgan Ent LLC · Richland, IAN9259CHauser Linda L · Ulysses, KSN9259HBooke Phillip Austin · Anniston, ALN9259UAdirondack Legacy Aircraft LLC · Saratoga Springs, NYN925ABJavelina Trax LLC · Saint Charles, MON925CBDhani Errol · Locust Grove, GAN925JKLonghorn Listings Inc · San Antonio, TXN925MML A M Capital Management LLC · Sheridan, WYN925PBRegistered aircraftN925RRHahn John K · Evansville, INN925WMHoward Charles M · Pittsburg, TXN92600Windh Steven R · Reedley, CAN9260CWilson Benjamin W · Carrollton, TXN9260GPeyton Julia H · Santa Barbara, CAFirst renewal noticeN9260RVroom David H · Oro Valley, AZN9260UFlying L Aircraft Inc · Fort Denaud, FLN9260XColvin Buster · Big Cabin, OKN92616Holby W Barrett Jr · Warren, RIN92617Stahl Raifen · Anchorage, AKN9261ACallahan Glenn P · Deridder, LAN9261GAllred Bobby A · Centre, ALN9261HSchrom Frederick A · Carlisle, PAN9261UOconnor Sean P · Pompano Beach, FLN9262HAero Maintenance Inc · Vancouver, WAN9262UNichols Curtis E · Gloucester, VAN92638Van Raden Chris · Portland, ORN92639Pryor Aviation LLC · Hutchinson, KSN9263GN9263g LLC · Marshall, MON9263HPj Aviation Holding LLC Trustee · Eden Prairie, MNN9263XMieloszyk Nicholas A · Elko, NVN92644Atkins Doug · Murfreesboro, TNN92648Bender Phillip H · Bloomingdale, OHN9264RAir Dakota Flite Inc · Hettinger, NDN9265CComerford John W · Pagosa Springs, CON9265HCleveland Douglas P · Live Oak, FLN9265TFpg Agri Services LLC · Frost, TXN9265UEtchell Bruce R · Healdsburg, CAN9265XWestern Pilot Service Inc · Phoenix, AZN92665Rupke Curtis · Washington, NCN9266ADyrstad Mary S · Hampshire, ILN9266GCole Mark A · Forest City, NCN9266UEgge Danny C · Pelican Rapids, MN
Back to AD 87-20-03 R2