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.
N676CHTake Off Aviation Services LLC · Rockledge, FLN676DWSunrise Aviation Inc · Ormond Beach, FLN676ECCastle Joseph E · Marietta, OHN676FLEdwards William J · Big Rapids, MIN676HWinterbottom Eric A · Beavercrk Twp, OHN676MMButler Nathaniel J · West Fargo, NDN676NLoftus Timothy P · Mclean, VAN676QKeil Urban G · The Villages, FLN676SECircle K Aircraft Leasing LLC · Houston, TXN676TFAeon62 Holdings LLC · Plano, TXN676WLeymaster Michael J · Westerville, OHN676YMarvin James · La Verkin, UTN67701R&R Aero Services LLC · Eden Prairie, MNN67705Registration Pending · Tacoma, WARegistration pendingN67708Pischel Tom K · Meadow Vista, CAN6770NGrant William S · Azle, TXN6770VDobalian Vaughn E · Jacksonville Beach, FLN67710Hillsboro Aero Academy LLC · Hillsboro, ORN67711Cox Linda M · Christiana, TNFirst renewal noticeN6771FDecruz Enterprises LLC · Hattiesburg, MSN6771VBrice Michael · Dickinson, NDN67728Edj Aviation Ltd · Fort Myers Beach, FLN6772JMaljanion Mark D · Upton, MAN6772NHapp Michael E · Valley Center, KSN6772WKolb Lowell E · Rapid City, SDN67733Righter Douglas D · Bellingham, WAN6773JTuskegee Airmen National Historical Museum Inc · Detroit, MIN6773NMills David J · Combine, TXN6773VSouthern Mooney Inc · Wilmington, DEN67746Air-Planes LLC · Soddy Daisy, TNN6774BLegacy Aviation And Sales LLC · Ririe, IDN6774DSouthern Cross Aviation · Wilmington, DEN6774UFair Weather Holdings LLC · Centennial, CON6774W10-4 Aviation LLC · Waco, TXN67753Southwinds Export Inc · Kissimmee, FLN6775BOcean Aerial Ads Inc · Berlin, MDN6775FPittsburgh Flying Club Inc · Greensburg, PAN6775NAirvantage Global LLC · Lake Worth, FLN67760Farquar Leasing Inc · North Bend, ORN67765Guilbeau Austin K · Miami, FLN6776DMilam Inc · Trussville, ALN6776JLanier Bradley N · Asheboro, NCN6776NClark Jeff N · Arab, ALN6776UParmer Jeffrey C · Redondo Beach, CAN67778Wings Over Texas Holdings LLC · Denton, TXN6777BJim Franklin Aviation Service Inc · Ruidoso, NMN6777JSeven Seven Juliet LLC · Palmer, AKN6777NStephens Mark A · Las Vegas, NVN6777TNeff Tj · Novato, CAN6777ULongmont Mooney · Longmont, CORevoked, canceled
Back to AD 90-04-06 R1