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.
N79321Registered aircraftN79323Carstairs Energy Inc · Los Osos, CAN79325Gill Sandeep S · Southlake, TXN79326Campbell Scott W · Del Mar, CAN79327Hobby Randy K · Santa Claus, INN79329Resource Capital Inc · Henderson, NVN7932NMyers Richard J · Lebanon, TNN7932WBlaine Richard A Jr · Boardman, OHN79330Prater Kerrie J · Maurice, LAN79334Lewis Troy D · Clarkston, MIN79337Thoreson Alvin J · Granada, MNN79338Baber Fredrick Marshall · Punta Gorda, FLN7933CLaytham Ricky A · Coatesville, PAN7933NCc Aero Services LLC · Bullard, TXN7933PFoss Rick · Lemmon, SDN79340Windsperger Kevin L · Kirksville, MON79341Sigmon Thomas W · Surprise, AZN79344Seley Ronald J · South Pasadena, CAN79346Chandler John · San Gabriel, CAN79347Aguilar William A · Puyallup, WAN7934G7550g LLC · Birmingham, MIN7934WAir Roanoke Ltd · Roanoke, VAN79350Ocala Aviation Services Inc · Ocala, FLN79351Dust Devils Aviation LLC · Richland, WAN79358Henderson Steven R · Madison, WIN79359Schultz Steven R · Tea, SDN7935CRfc Inc · Hiawatha, IAN7935NTorrington Flying Club Inc · Torrington, WYN7935PBarnett Michael DBA · The Woodlands, TXN7935WRather Be Flying LLC · New Castle, DEN79360Lewis Robert T · Avondale, AZN79361Narayan Systems LLC · Dayton, OHN79362Esfandiari Ozra · Las Vegas, NVN79363Holmes Shaun B · Georgetown, TXN79365Durden Bobby D Jr · Statesboro, GAN79368Jmr Investments LLC · San Antonio, TXN7936GWatson Carlton D · Campbellsville, KYN7936PHawkins Robert J · Lamesa, TXN7936WHiller Jeron P · Marshfield, WIN79374Johnson Stephen C · Columbus, OHN79378Janoski David Michael · Fort Worth, TXN7937PMr Dent Inc · Manheim, PAN7937WYang Zhongyi Deroll · Oro Valley, AZN79380Marr Steven K · Saint Charles, MON79382Hood Gary L · New Caney, TXN79383De Michele Fabio Jose Delgado · Pembroke Pines, FLN79387Luckenbach Adam W · Friendswood, TXN79388Mulligan Lawrence · Murray Hill, NJN7938CVolar Corp · El Cajon, CAN7938GDelaney Patrick James · Marion, TX
Back to AD 87-10-06 R1