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.
N8215PAme LLC · Kalispell, MTN8215YGlassburn Teresa L · Winthrop, WAN82162Conner Larry W · Los Lunas, NMN82165Piper Aircraft Inc · Vero Beach, FLN82166Minuteman Aviation Inc · Missoula, MTN82168Earth Center Adventures Inc · Haines, AKN82169Patterson Colin G · Ballston Spa, NYN8216CYoung Mikaela R · Fairbanks, AKN8216NShelton William B · Wildwood, MON8216PBobbitt Aviation LLC · Edenton, NCN8216SNulton Enterprises LLC · Johnstown, PAN8216TRegistered aircraftN8216WBritair Inc · Austin, TXN8216YMedia Stew LLC · Carson City, NVN82172Wadekamper Leo V · Helena, MTN82173Gagnier Hugh K · Hidden Hills, CAN8217NG U M P S Flying Club Inc · Warner Robins, GAN8217PDanilchuk Phillip A · Auburn, GAN8217QParis Air Inc · Vero Beach, FLN8217SValles Robert Jr · Spicewood, TXN8217YMaledy John Trustee · Salem, MON8217ZPerry Richard F · Lexington, MAN8218Kornegay Patrick C · San Benito, TXN82188Kubecka Daniel P · Edna, TXN8218AFirst Flight Inc · Watertown, CTN8218CStargazer Aviation LLC · Clearwater, FLN8218KN8218k LLC · Chico, CAN8218NLee David · Palm Springs, CAN8218ZWingsleasing LLC · Wichita, KSN82196Flying W Ranch Jv · Cooperstown, NDN8219WA18 Missions LLC · Clinton, MON8219YDurden Julian F Jr · Twin City, GAN821BERas Aviation LLC · Elyria, OHN821BFDehn Timothy E · Braham, MNN821CPCivil Air Patrol · Maxwell Afb, ALN821DBFlying Old Glory LLC · Kalispell, MTN821DHMilsap Charles M · Owensboro, KYN821ESSchmitz Mark J · Ames, IAN821FASlavin Marc · Berlin, MDN821FJ8th Dimension Enterprises LLC · Aurora, ORN821GMHoosier Aviation LLC · Terre Haute, INN821KCIreland Robert D Jr · Gulf Breeze, FLN821LLindrooth Steven A · Perkasie, PAN821PASkywest Leasing Inc · St George, UTN821PCJones Clark L · Cave Creek, AZN821PTHermes Ana Paula F · West End, NCFirst renewal noticeN821RFAlaska Island Air Inc · Togiak, AKN821RGCircle Z Construction LLC · Mancos, CON821RRAir Charter Inc DBA · Culebra, PRN821SDGlobal Adventures N821sd LLC · Hollywood, FL
Back to AD 87-10-06 R1