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.
N7766WBair Dale Leroy · Canton, OHN7767GPerformance Aviation LLC · Fort Myers, FLN7767PStock Keith A · Warrensburg, MON7767WFinan Kevin P · Seattle, WAN7768MHoyle Charles D Jr · Eureka, CAN7768NLeap Frog Aviation LLC · Bentonville, ARN7768PGreensburg Jeannette Airport Administration Inc · Jeannette, PAN7768VSky Sailing Inc · Warner Springs, CAN7768WKilo Niner Aviation LLC · Saint Petersburg, FLN7769Sherburne Asher J · Redlands, CAN7769MCorso Nicholas J · Stuart, FLN7769NWoolsey Bradley W · Burleson, TXN7769WSeverson Michael A · Nampa, IDN7769ZCentral Air Parts Inc · Staunton, ILN776ACMonska Stephen M · Florence, MAN776AWKustatan Leasing LLC · Nikiski, AKN776BCTyndall Darryl K DBA · Deep Run, NCN776CAChristiansen Aviation LLC · Wilmington, DEN776CHHassler William J · Houston, TXN776DGArmbruster Richard G · Chardon, OHN776DLSky West Aviation Inc Trustee · Albuquerque, NMN776GAtp Aircraft 9 LLC · Wilmington, DEN776GAHinds Community College · Raymond, MSN776JNSchemmel Grant P · Florence, CON776LHJones Aircraft Company LLC · Cross Plains, TNN776MCCrew Sourcing Inc · Wilmington, DEN776NDUniversity Of North Dakota · Grand Forks, NDN776NHHylton Nathaniel Dean · Pleasant Plain, OHN776RMiano Steven Mitchell · Clearwater, FLN776RVThams Kurt T · Soquel, CAN776SHExplore Helicopters LLC · Lexington, ALN776WBcww LLC · Bakersfield, CAN7770BDunning John L · East Hampton, NYN7770CMcgee Ronald S · Waco, KYN7770DJenkins Robert H · Kill Devil Hills, NCN7770GMyers Keith R Trustee · Fond Du Lac, WIN7770NThompson Brad J · Pleasant View, TNN7770PGlau Jon E · Englewood, CON7770WN7770w LLC · Sheridan, WYN7771GEmpire Aero Club Inc · Sebastopol, CAN7771NSale Reported · Copper Center, AKSale reported, pending cancellationN7771RWeatherbee Mark B · Lincoln, MEN7771WWhitman Edward G · River Falls, WIN7771YDakota Executive Flight Inc · Miller, SDN7772CCummings David P · Grayson, LAN7772DWilliams Stephen M · Fort Walton Beach, FLN7772GWings Over Texas Holdings LLC · Denton, TXN7772HGws Contractors Inc · Bonne Terre, MON7772NZmq Aviation LLC · Minneapolis, MNN7772VHauser Linda L · Ulysses, KS
Back to AD 87-10-06 R1