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.
N8930DBeverly Lester E · Shepherd, TXN8930JMccracken Blake R · Lake Havasu City, AZN8930MCuratola Bruce J · League City, TXN8930WMaurer Mark · Alamogordo, NMN8931PDuncan Michael J · Cordova, TNN8931VAeroventures 8 LLC · Mt Carmel, TNN8932DRegistration Pending · Caldwell, IDRegistration pendingN8932MOlivieri Michael R · Wasilla, AKN8932P260b LLC · San Diego, CAN8932VEverett William M · Tuscumbia, ALN8932YStrohmeyer Gregory C · Wasilla, AKN89337Davis Andrea E · Lake Oswego, ORN8933DGrandy Leland P · Rock Springs, WYN8933JQuilling John R · Cannon Falls, MNN8933LDuncan Aviation Inc · Lincoln, NEN8933WFlight Time LLC · Portland, ORN8934PNermernuh LLC · Chester, CTN8934VUniversal Aviators Academy Inc · El Monte, CAN8934WNelson Cy D · Decorah, IAN8934YFuller John M · Minden, NVN8935WJudd Ellen K · Burley, IDN8936JCloud Niners Inc · Brownsburg, INN8936PGesenhues Bernard J · Canton, OHN8937DBrunner Steve W · Mission Viejo, CAN8937LHood River Soaring · Hood River, ORN8937NSchewe William M · Greenville, ILFirst renewal noticeN8937RBeckett David · Wasilla, AKN8937VCowden Steven B · Bellingham, WAN8937WArmstrong Wanliss E · Jal, NMN8938FSouthern Cross Aviation Inc · Wilmington, DEN8938JMeier Daniel J · Greenwood, INN8938YUniversity Of Alaska Anchorage · Anchorage, AKN8939CRegistration Pending · Lakota, NDRegistration pendingN8939JEstis Jonathan D · Walden, NYN8939LWestern Carolina Ag Air Inc · Catawba, NCN8939NOakley William J · Kildeer, ILN893ACAri Ben Aviator Inc · Fort Pierce, FLN893CBAec Navajo LLC · Wilmington, DEN893DCCorporate Air Charter Inc · Wilmington, DEN893FSSmith Francis H Jr · Lyons, CON893LTLamb James R · Hobe Sound, FLN893SHHowell Steven P · Oklahoma City, OKN894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeN8940JMullins David H · Zebulon, GAN8940PDavie Andrew S · Stony Point, NYN8941DMain David W · Blounts Creek, NCN8941JTilghman Michael B · Salisbury, MDN8941VSky Castle Aviation LLC · New Castle, INN8941WSalisbury Airplane Associates Inc · Berlin, MDN8942DCwynar Scott L · Toledo, OHFirst renewal notice
Back to AD 87-10-06 R1