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.
N824NDUnd Aerospace Foundation · Grand Forks, NDN824PAHot Wings Aviation LLC · Indianapolis, INN824PCHardee Jewell E · Keller, TXN824PJDowney Joseph E · University City, MON824PKReisdorfer Mark J · La Follette, TNN824RVNielsen Matthew · Enterprise, ALN824SLMccaskie Stephen L · Jonestown, TXN824SVMarsh Victor W · Tracy, CAN824SWWatts Stanley A · Woodstock, GAN824TRLand Air Enterprises Inc · Boynton Beach, FLN824VRDodson International Parts Inc · Rantoul, KSN824WSHampton Roads Charter Service · Chesapeake, VAN82502Christofferson Kevin · Fruita, CON82504Pentecost Benjamin I · Puyallup, WAN82505Kunkle Christopher · Santa Ynez, CAN82508Jones Matthew B · Wasilla, AKN8250CAcme Cub Training Inc · Anchorage, AKN8250NBruce James E · Greenfield, INN8250WMorehead Leonard E · Bryan, TXN8250YStoltz Kevin · Locust Grove, GAN82512Reed Charles H · Shelbyville, KYN82518Zeafla Randall Reis · Elizabethtown, KYN8251DSwenson Roger A · Pahrump, NVN8251FSchneider Ryan S · Colorado Springs, CON8251NLarue Jesse W · College Station, TXN8251SAirlife Aviation LLC · Elkridge, MDN8251WKeddis Moheb N · Fairfax, VAN82520Newman Scott W · Healdsburg, CAN8252CRoberts Dave C · Wibaux, MTN8252EMiami Flight Training LLC · Miami, FLN8252NWhiting Reed Brandon · Mesa, AZN8252PMontgomery Daniel G · Wasilla, AKN8252ZHodges Albert H Executor · Lyons, GAN82530Flowers Christopher L · Anchorage, AKN8253AArcher N8253a LLC · Orange, CTN8253GHudson Allen N · Bowling Green, KYN82544Cronquist Korey J · Wasilla, AKN82547Jeffries Aviation LLC · Kalispell, MTN82549Airgo Incorporated · Centralia, ILN8254EPerfect Agreements Leasing · Trabucco Canyon, CAN8254FStewart Rodney W · Pensacola, FLN8254JParis Air Inc · Vero Beach, FLN8254NBlum William C · Alma, NEN8254YCrimson Aviation LLC · Helena, MTN82554Garnet Aviation LLC · Fort Worth, TXN82557Zehm Laura L · Monterey, CAN8255GCentral Virginia Aviation Inc · North Dinwiddie, VAN8255PKanooth Michael L · Washougal, WAN8255WReed Emerson E · Winter Haven, FLN82563Registered aircraft
Back to AD 90-04-06 R1