AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N186JPSogge Mark · Floyds Knobs, INN186KBAims Community College · Greeley, CON186LUS Department Of The Interior · Boise, IDN186MAMullins Robert · Dublin, TXN186PDStarfighter Holdings LLC · Port Townsend, WAN186RSSpears Jason · Milton, WVN186SAClemente Motor Inc · Troy, NYN186SHContinental Helicopters Inc · Sheffield, TXN186SPClear2 Aviate LLC · Ionia, MIN186TCNauti By Nature LLC · Colorado Springs, CON186WWWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZN186XHaldeman Hangars LLC · Vancouver, WAN1871SGreen Evan R · Calabasas, CAN18720Bailey Bryan M · New Waverly, TXN18725Ayers Francis H Jr · Palm Coast, FLN18728Atlas Aviation Tampa Inc · Tampa, FLN1872EAmerican Valet Air Inc · Wilmington, DEN1872HDodson International Parts Inc · Rantoul, KSN18738Cardinal Flyers Inc · Northborough, MAN18739Monaco Michael · New Windsor, NYFirst renewal noticeN18767Zimmerman Patrick Joseph · Roseburg, ORN18769Shiel Penny S · Palisade, CON1876SSteward James M · Colorado Springs, CON18770Robinson Jere L · Burnet, TXN18774Sarasota Avionics Inc · Venice, FLN18782Stagman Andrew A · Land O Lakes, FLN18783Bates Gary D · Niles, MIN18787Ostrowski Brian Keith · Jerome, MIN1878JCarter Tim R · Morgan, UTN18791Registration Pending · Stevens Point, WIRegistration pendingN18793Berns Robert D · Clifton, ILN18795Bock Patrick D · Phoenix, AZN18798Herald Jason E · Tulsa, OKN187AMDh Aviation Products LLC · Missoula, MTN187CACivil Air Patrol · Maxwell Afb, ALN187CCFederico Leonard A · Reno, NVN187DBSummerwind Aviation LLC · Mooresville, NCN187GJerchau Ryan P · Bellmore, NYN187HSGlidewell Aviation Inc · Parkland, FLN187JHSouthern Ag Helicopter Services LLC · Zebulon, NCN187JWBriley Christopher P · Lynchburg, VAN187MHP&V Howard Enterprises LLC · Angleton, TXN187PSMorrissey John C Col · Lees Summit, MON187SPFarwick Brent T · Louisville, TNN187TATech Air LLC · Lexington Park, MDN187TCRiesenberg Tyson Robert · Bountiful, UTN187TPR G R Holdings LLC · Spring Branch, TXN187TXXin Han Aviation LLC · Atwater, CAN1882SWings Over L A Aviation LLC · West Hills, CAN18841Quality Aviation Inc · Atlanta, GA
Back to AD 2006-10-21