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.
N7683FFisch David S · Leland, NCN7683GBalgoyen James T · Charlotte, MIN7683HNovember Alpha LLC · Dover, DEN7683PCavel Lonnie R · Vidor, TXN7683SSzabolscky Stephen L · Remington, VAN7684DRegistration Pending · Destin, FLRegistration pendingN7684FLettunich Mitchell C · Newcastle, CAN7684PPache Keith M · Montgomery, TXN7684SStrehle Scott · Lewiston, IDN7685DMcdonnell Chris M · Naknek, AKN7685MLazy Double Air LLC · Bloomer, WIN7685PPinkel Lawrence W · Albuquerque, NMN7685SHull Kevin G · Sadler, TXN7685YNehrbass Douglas J · Clarksville, TNN7685ZHigh Flights Soaring Club Inc · Peyton, CON7686FBaremor Terry A · Brooklyn Park, MNN7686JCovic Craig A · Cordova, TNN7686WEcho Aviator LLC · Whitehouse, OHN7686YMontana Leasing Group LLC · Park City, UTN7687MMckown Kevin · Edgewood, NMN7687RTaylor Edward P Jr · Spanishburg, WVN7687SLynn Robert W · Independence, WVN7688Jte Properties LLC · Azle, TXN7688CCable Bradley D · Indianapolis, INN7688DMiller Gregory B · Wasilla, AKN7688JClapp Rollyn D · Volga, SDN7688LConsag LLC · Ainsworth, NEN7688RTrudeau Lemaster Productions · Woodland Hills, CAN7688SJohnson Brian G · Goodridge, MNN7688WBurns Joyce A · Sparta, MON7689GMerrihew Jerry R · Ashby, NEN7689RDelehant Edward J III · Keller, TXN7689YGitlow Stuart · Woonsocket, RIN768AMeridian Aircraft LLC · Wilmington, DEN768ACBowe Joseph E · Ocklawaha, FLN768AZStinker Air LLC · Reno, NVN768CStieren George L · Kerrville, TXN768CACollet Mark · Plymouth, MAN768FAnderson William Keven · Mc Gregor, TXN768GASumner Gary · Knoxville, TNN768KAFrizzell Alex A · Auburn, ALN768NDUniversity Of North Dakota · Grand Forks, NDN768PEMts Inc · Middletown, DEN768SHHoffman Stephen A · Hereford, TXN768SPLast Sea LLC · Saint Augustine, FLN7690FSparke Richard · Downers Grove, ILN7690JFox Two LLC · Camino, CAN7690SCollum Aviation LLC · Milton, FLN7690UPiper Aircraft Inc · Vero Beach, FLN7690WEngelhuber Robert H · Beulah, MIFirst renewal notice
Back to AD 87-10-06 R1