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.
N212TVParagon Airplane Leasing Co · Fort Myers, FLN212WARowland Roger A · Nampa, IDN2130FSilverhawk Aviation Academy LLC · Caldwell, IDN2130JEarly Bird Aviation LLC · Rillito, AZN2130RAscend Aviation LLC · Ira, MIN2130TWasson Ronald L · Colleyville, TXN2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MON21313Foster Peter · University Park, TXN21318Raw Racing Inc · Puyallup, WAN2131ATru Flight Materials LLC · Wilmington, DEN2131ESchuman William C II · Poplar Grove, ILN2131JAllen Harvey · Elfrida, AZN2131TMullin Thomas F III · Birmingham, ALN2131UAgh Property Investments Inc · Key West, FLN2131WRussek Rick · Cave Creek, AZN2132JHolley William M · Rock Port, MON2132WWheeler Equipment Leasing LLC · Gainesville, GAN2132XChampionx LLC · Sugar Land, TXN21339Pilots Flying School LLC · Englishtown, NJN2133ASchnack Kenneth L · Crescent, IAN2133JHoosier Aviation LLC · Terre Haute, INN2133LGietzen Jeff · Seattle, WAN2134ERice Larry Anthony Trustee · Yucaipa, CAN2134JMcmahan Michael Anthony · Dunwoody, GAN2134MChristiansen Aviation LLC · Wilmington, DEN2134RVanek Peter · Sedona, AZN2134SC Squared Inc · Stevensville, MDN2134TBartow Municipal Airport Development Authority · Bartow, FLN2134WJustison David L · Hillsboro, ILN21352Lane Shannon L · Hopkinsville, KYN21356Elite Financial Management Inc · Dallas, TXN21357Wild Outdoors Oil LLC · Velma, OKN2135FMark Alan Bennett · Trinidad, CON2135KJet Air Inc · Iowa City, IAN2135SEastern Cincinnati Aviation Inc · Batavia, OHN2135TPeter Prince Aviation Center LLC · Milton, FLN21369Smk Holdings LLC · Sandy, UTN2136CPope Keith D · Mineral Wells, TXN2136JHanus John E · North Kingstown, RIN2136ZPorta Frank T · Charleston, WVN21372Halbert Ronald S · San Diego, CAN2137EMbg LLC · Mountain Home, IDN2137FColakoglu Migirdic · Hilton, NYN2137TWatson Jay C · Midland, TXN2138BSouthwest Aviation Enterprises · Haslet, TXN2138FCima Christopher P · Plano, TXN2138KGrigsby Aaron A · Victorville, CAN2138NJ T Air Inc · Dayton, MDN2138RWisdom Victor · Sterling, CON2138WChristiansen Aviation LLC · Wilmington, DE
Back to AD 2006-10-21