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.
N770TCMyers Benny R · Wasilla, AKN770WHJacobson Luke W · Reno, NVN7710KAtd Pilot Training LLC · Kansas City, MON7710MNavarre Curtis R · Chandler, AZN7710NSimpson Chad M · Dover, OHN7710WRegistered aircraftN7711Thomas Conrad H K · Lake City, FLN7711KVisser Paul C · Junction City, KSN7711MStauffer Michael S · Wichita Falls, TXN7711PWhitewater Aviation Inc · Harrison, OHN7712FRice Robert Dalton · Kerrville, TXN7712JChapman James A · San Antonio, TXN7712PLenbom Mark A · Cameron, WIN7713Jf Aerosports LLC · Vineland, NJN7713GDavenport Jimmy J · Hayesville, NCN7713NSingh Harsimran · Las Vegas, NVN7713PFoster Mica J · Derby, KSN7713WBarber Mark E · Lighthouse Point, FLN7713YDarragh Jeff · Fort Myers, FLN7714CLuebow Jens · Madison, WIN7714DZapata James A · Fallbrook, CAN7714GGlynco Manning Aviation Inc · Brunswick, GAN7714WCrosswinds Flight Center Inc · Drums, PAN7714ZSimmons Aviation Services LLC · Pawcatuck, CTN7715DIriarte Christopher P · Grosse Ile, MIN7715GAirborne LLC · Wilmington, DEN7715NK Heart Aviation LLC · Choudrant, LAN7715WFoster Kenneth D · Saint Maries, IDN7715ZMiller Aviation Inc · Norton, KSN77160Fahmy Bishoy F · Fraser, MIN7716GFirst Eclipse Ltd · Richmond, VAN7716JQuinn Andrew · Fort Worth, TXN7716NPyanov Mark · Clinton, MSN7716PWhite Donald R · La Ward, TXFirst renewal noticeN7716WWood Burton T · Richmond Hill, GAN7716ZBig Aerial Sign Service LLC · Delano, MNN7717GJohnson Eric C · Turtle Lake, NDN7717HJohnson Paul C · Tower, MNN7717JFlying High Aviation LLC · Kalispell, MTN7717NAdirondack Flying Club LLC · Rome, NYN7717VCarver Aero LLC · Muscatine, IAN7717WFouse Timothy · Kittanning, PAN7718AScud Air 18a LLC · Morgan, UTN7718JPrcs Logistics LLC · South Bound Brook, NJN7718NKlinedinst D Eric · Carlisle, PAN7718PVan Develde Robert K · Troy, MIN7718WClyde Fliers Inc · Fremont, OHN7719JMaduro Dudley C · St Thomas, VIFirst renewal noticeN7719PSchidlowsky Michael · Otis, MAN7719WKnudson Douglas E · Morris, IL
Back to AD 87-10-06 R1