AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N511LMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN511MGCrock Dominic D · New Concord, OHN511MPN511mp LLC · Wilmington, DEN511PReigle Aviation South LLC · Orlando, FLN511PCClear Skies Avionics Inc · Clearwater, FLN511PRPfaff Joseph G · Woodbridge, VAN511PTCappe Investment Group LLC · Homestead, FLN511RFOlson Dean W · Shelbyville, KYN511RJCarman Scott C · Port Orange, FLN511SFFowler Ronald W · Lopez Island, WAN511SGHeinze Gregory L · Little Rock, ARN511STTilford Stephen J · The Villages, FLN512Birdwell Larry · Cedar Hill, TXN5120GGoering Vincent R · Hephzibah, GAN5120HTraining Planes LLC · Tampa, FLN5120LClifford Scott P · Wallkill, NYN5120SIntentus Aviation LLC · Sunset, TXN5120TPrince Ronald D · Beach City, OHN5120WSeasons Of Life Publications LLC · Greenville, SCN51213Shelley Aaron J · Corbin, KYN5121GWingsleasing LLC · Wichita, KSN5121HGilsdorf Jason M · Henning, MNN5121KTebbe Francis L · Maryville, ILN5121QClift William R II · Princeton, KYN5121SSandmann Ross · Plano, TXN5121TBourn Rachael · Magee, MSN5121WCarroll Thomas F · Independence, MON5121ZDahlberg Thomas K · Belvidere, ILN51221Provost Kevin H · North Swanzey, NHN51222Mbk Leasing And Consulting LLC · Lakeland, FLN5122BTutt Bryan D · Louisville, KYN5122LJuliet Sierra Foxtrot LLC · Denver City, TXN5122PBluesky Equipment LLC · Panama City, FLN5122R1st Clev-Mar LLC · Lakeview, ARN5122SKudla Frank R · Bean Station, TNN5122WSale Reported · Cape Elizabeth, MESale reportedN5122ZDunn Kohlten Davis · Rexburg, IDN51236Christiansen Aviation LLC · Wilmington, DEN51238Flying G Aviation Inc · Drayton, NDN5123EMiller Kenneth Allen · Riverhead, NYN5123JCircle W Flying Club Inc · Creighton, PAN5123NOakley Linwood E · Zebulon, NCN5123RGiving Wings Aviation LLC · Traverse City, MIN5123SChristopher Craig · Colbert, WAN5123TSlaughter Patricia C · Saranac, MIN5123VAustin Jeffrey L Trustee · Salem, ORN5123WVaughn Jesse L · Poplar Bluff, MON51240Young Roger P · Sewickley, PAN51249Flying Turkey LLC · Flower Mound, TXN5124BHillsboro Aero Academy Llcc · Hillsboro, OR
Back to AD 90-04-06 R1