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.
N8546FBarts Flying Service Inc · Storm Lake, IAN8546NBeaver Brook Aviation LLC · Scotia, NYN8546WNowos Monica Leigh · Rochester Hills, MIN8547PStewart James David · Mesa, AZN8548Collum Aviation LLC · Milton, FLN8548ZBank Of Utah Trustee · Salt Lake City, UTN8549Koenig Steven T · Ostrander, OHN8549AEbel Keith E · Shell Knob, MON8549NDowning Ray E III · Topeka, KSN8549PWest Texas Weather Modification Association · San Angelo, TXN8549WAllstead Bradley E · Trenton, MIN854ACKurchian Aram M · Sunland, CAN854AKAraki Satoshi · Hayward, CAN854CAJunie The Flying Dog LLC · Atlanta, GAN854DRDix Mark · Wray, CON854DZHohnadel R Michael · Harlingen, TXN854GRegistered aircraftN854GWCondair Flyers Inc · Latham, NYN854HCN854hc LLC · Watkinsville, GAN854NDAero Equities LLC · Ventura, CAN854PD139th Aeroclub LLC · Miami, FLN854RVRoberts Thomas G · Seattle, WAN854TBBrown Thomas R · Gainesville, FLN854TCBeech Construction Inc · Pittsburgh, PAN854VLBlue Waters Air Charters LLC · San Juan, PRN854WSMn Helicopters Inc · Minneapolis, MNN85503Merrells Grade-All Inc · Saint Cloud, FLN8550DRiester Gary R · Navarre, FLN8550LHigh Desert Soaring Clubinc · Bend, ORN8550PNick Smith And Associates Inc · Mcallen, TXN8550RCockpit Holdings Corp · Melbourne, FLN8550UThompson Peter S · New Hampton, NHN8550WRegistration Pending · Nampa, IDRegistration pendingN8551DCordingley Robert L II · Lafayette, CON8551LQuality Avition Inc · Marana, AZN8551NRegistered aircraftN8551PBratcher Troy L · Williston, NDN8551VTall Timber Flying Service LLC · Kalispell, MTN8551WDaideo Enterprises LLC · Slingerlands, NYN8552DSvec Adolph Ralph · Marengo, ILN8552LWhittington John H Jr · Dillon, SCN8552VBurkey Dale · Walnut, ILN8554DParks Alan J · Homer, AKN8554VPaulson Marshall R · Kenai, AKN8555Bank Of Utah Trustee · Salt Lake City, UTN8555WSottile Andre M · Monroe, MIN8555YScharf Mark T · Rosamond, CAFirst renewal noticeN8556PLandis Ehrin · Redding, CAN8556VParis Charles F · Pioneer, LAN8556WBeans And Cool Dude LLC · Denton, TX
Back to AD 87-10-06 R1