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.
N8857NWolf Terry T · Lake Katrine, NYN8857YLewis Leslie S · Glendale, AZN88587Tucker Anthony W · Brazoria, TXN8858CLebron Renard Jr · Gulfport, MSN8858JBirdie N88 LLC · Conifer, CON8858LRedro Inc · Owatonna, MNN8859DBbc Group LLC · Sanford, NCN8859NThrash Enterprises LLC · Clarksville, TNN885ACWingsleasing LLC · Wichita, KSN885ATDot Aviation LLC · Wilmington, DEN885CFJulian Michael · Las Vegas, NVN885FTFlorida Institute Of Technology · Melbourne, FLN885SABlevins Edgar R · Zachary, LAN885SMDews Robert Mark · Jefferson, TXN8860DCooley Tony A · Dallas, ORN8860JBjg LLC · Langdon, NHN8860LCrowe George J · East Ridge, TNN88610Cape May Aerial Advertising LLC · Rio Grande, NJN8861FMurtaza Syed S · Minneapolis, MNN8861NMcdonald Timothy A · Rush City, MNN8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKN8862LTisdale Matthew · Alameda, CAN8862NHatley Wayne S · Hermitage, TNN8862TAdams Donald L · Huntsville, ALN8862YState Of Montana · Helena, MTN8863CClearsky II LLC · Tyler Hill, PAN8863DSanders Darrel T · Camp Douglas, WIN8863FCain James W · Big Rapids, MIN8864DMarsteller Paul A · Tallulah Falls, GAN8864LArnold Charles E · Lowell, MAN8864YMiller Donald W · Harrisonburg, VAN8865CMayo Jesse J · Fairbanks, AKN8866CEckels Shaun R · Pickerington, OHN8866FReynolds Darryl G · Wills Point, TXN8866NYu Hermon Lemuel C · Mays Landing, NJN8866YCarson Ryan P · Albuquerque, NMN8867NMulloy Dennis · Indian Mound, TNN8867PAnderson Keith C · Puyallup, WAN8867YPiper Thirty Nine LLC · Glasgow, MTN8868Hodges Jay W · Graham, TXN8868JGannon Robert M · Hamburg, NYN8869JRoot Roger T · Moscow, IDN8869NCarland Ralph B · Altoona, PAN8869YCome Fly Away LLC · Waterloo, ILN886ACAir Ben Aviator Inc · Fort Pierce, FLN886ATDot Aviation LLC · Wilmington, DEN886BNairn Bryan D · Edgewood, WAN886ECUp And Up Aviation LLC · Magnolia, TXN886PBarrons Aviation Services LLC · Henderson, NVN886RASmith Daryl N · Coventry, CT
Back to AD 90-04-06 R1