AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N4075ABowen Hal S · Sandpoint, IDN4075EKimbrough Dale M · Goodlettsville, TNN4075FPrice Timothy C · Rancho Cucamonga, CAN4075JB&R Aircraft LLC · Wadsworth, OHN4075UWright Joseph G · Medicine Lodge, KSN4076FStebbins Robert A · Cookson, OKN4076UKoehn David Scott · Orange Beach, ALN4076VPennington Charles A · Fort Smith, ARN4077ECalef Jere Trustee · Mojave, CAN4077FSolomon Joseph E Jr · Modesto, CAN4078FJanes Christopher D · Columbia, KYN4078NAlexander Robert B · Brooksville, FLN4078UHoover Michael B · Ridgeland, WIN40791Porter David E · Woodstock, GAN40795Greycat Aviation LLC · Chesapeake, VAN4079ESpranger Paul L · Valley Center, KSN4079FCovington Gary N · Midland, TXFirst renewal noticeN4079NKozycz Nathanael J · Penryn, CAN4079UScribner Jeffrey D · Upton, MEN4079VGovednik Frank J · Nipomo, CAN4080AHock Wesley S · Holbrook, NEN4080FGoggans John L · Mansfield, MON4080NStartin Chad E · Lacrosse, WAN4081NWallace Carey D · Knoxville, TNN4081VLark Thomas S · Coppell, TXN4082NCook Steven C · Hewitt, TXN4083UKadlecovic Martin · Prescott, AZN4084NBoike Andrew W · Federal Way, WAN40859Coffey James R Jr · Williams, AZN4085UHilderbrand Timothy S · Chicora, PAN4085VGeorge Daniel W · Reynoldsburg, OHN4086FShelton Joseph G · Kingman, AZN4086JBell Robert A Jr · Scotland Neck, NCN4086NLagno Frederick F · Queenstown, MDN4086VBoyd Darrell M · Claremore, OKN40870Braska Aviation LLC · Caro, MIN4087NKirby Timothy M · Ocala, FLN4087VYakima 65 N Flying Club · Yakima, WAN4088JLampasona Brendan T · Citrus Springs, FLN4088N4088n LLC · Springfield, VAN4088VSlezak Daniel S · Santa Margarita, CAN40895Kraus Russell E · Albemarle, NCN4089CBork Joseph L · Mosier, ORN4089VIhlenfeld Mark A · Owatonna, MNN408ARPeters Ronald L Trustee · Modesto, CAN408NSale Reported · Cades, SCSale reportedN40900Luginbuel Stacy W · Prairie Grove, ARN40907Skopek Darin A · River Falls, WIN4090FFox Aero Club · Catawba, NCN40910Culver Lane M · Laceys Spring, AL
Back to AD 94-05-05 R1