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.
N8414VWeller Steven C · Hummelstown, PAN8414WOhmacht Carlton J · Glenwood, MNN8414YLone Oak Aviation LLC · Greenville, NCN8414ZCunningham Stanley A · New Braunfels, TXN84151Sanders George W · Cloverdale, INN84153Spirit Air Inc · Salmon, IDN8415FGrediagin Wayne · Anchorage, AKN8415HAeronautica Aviation Inc · Port Orange, FLN8415PFathoms LLC · Leland, MIN8415RMahanna John A · Radcliff, KYN8415YSchwend Brian · Forsyth, MTN84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKN84169Roach Gene T · Frankfort, KYN8416JEmerald City Aircraft Leasing Inc · Port Orchard, WAN8416K8090 Alpha LLC · Grayslake, ILN8416RExpert Staffing West Inc · Ramona, CAN8416WCass Aviation LLC · North Las Vegas, NVN8416YHenze Charles R · Waukee, IAN84170Follmer Todd F · Dunwoody, GAN84176Brandywine Flight School · West Chester, PAN8417CDolan Joseph B · Baltimore, MDN8417JAtkinson Joseph M · Phoenix, AZN8417P250 Dash 4 Associates Ltd · Yellow Springs, OHN8417YHighhouse Alan J · Honesdale, PAN84183Chickadee Aviation LLC · Burr Ridge, ILN84185Harrison Gene R · Pendleton, ORN84186Gould George Jr · Bryantville, MAN8418CWingman Aircraft Repair Inc · Lawrenceville, GAN8418ETri-State Waterstoppers LLC · Ruffs Dale, PAN8418JBrown Jerry D · Rio Rancho, NMN8418RCarlsson Carl J · Mason City, IAN8418WMadison Mike · Pittsburg, TXN8418YHefner Joseph C · Mount Pleasant, TXN84190Frs & Craig Llp · Byron, GAN84193Smirnov Alexei · Fair Lawn, NJN84194Ultra Aviation LLC · Cedar Bluff, VAN84195Norcal Flight Center LLC · Lincoln, CAN8419CMarsh Geoffrey E · Old Lyme, CTN8419HHoke William Jr · Charlestown, INN8419JHammonds Hangars Inc · Wilmington, DEN8419RLytle Cole · North Palm Beach, FLN8419YMorrone Richard W · Westerly, RIN841ADCedar Real Estate Inc · Anaheim, CAN841AKOld City Helicopter Sales LLC · Saint Augustine, FLN841ATLuxury Transportation LLC · Talladega, ALN841BKKilpatrick Joseph C · Atlanta, GAN841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeN841EDR&D Aviation LLC · Fayetteville, GAN841GRegistration Pending · Painter, VARegistration pendingN841JARicci Theodore J · Spotswood, NJ
Back to AD 87-10-06 R1