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.
N2782KMurray Robert K · Las Cruces, NMN2782LSouthern Seaplane Inc · Belle Chasse, LAN2782UFrazier Doris C · Keller, TXN27837Muncie Sport Flyers LLC · Muncie, INN2783KElrod Brent W · Cashion, OKN2783NValbert Gilbert L · Martinsville, INN27844Montgomery Darrell R · Dayton, OHN2784HHudson Jason M · Toccoa, GAN2784SThomas Michael R · Marshall, MON2784UCobb Robert · Elberton, GAN2785HBal-Air LLC · Boca Raton, FLN2785UN2785u LLC · Hilton, NYN2786COttolini Alexander C · College Grove, TNN2786UBoos Daniel Paul · Jackson, WYN2787LGateway Flying Club Inc · Saint Louis, MON2787PNeubauer Scott · Wolf Point, MTN2787UNethery Autumn M · Shelbyville, KYN2789CRegistered aircraftN2789JStephens Mark E Trustee · Morgan Hill, CAN2789KColvin Clu D DBA · Big Cabin, OKN2789LChurch Sammy H · Statesville, NCN2789UKruse Russell E Jr · Siren, WIN278BDStubbs J Phillip · Richmond, VAN2790DRegistered aircraftN2790JLock Robert Allen · Grand Haven, MIN2790KThomson James W · Narragansett, RIN2790LWells Mark L · Eads, TNN27915Gruner Carl O · El Cajon, CAN27919Wellenstein Nic J · Big Sky, MTN2791HMoore James L · Humboldt, TNN2791JPuget Sound Flyers Inc · Everett, WAN2792CBerg Timothy J · Fairbanks, AKN2792NSanfillipo Leah M · Tehachapi, CAN2793Rohde Kenneth R · Pensacola, FLN27943Nedwick Lars I · Girdwood, AKN2794DBrown Rayford K · Temple, TXN2794KWallitner Raymond · Renton, WAN2794NDestefano Anthony J · Freehold, NJN2795CCales Jack R · Edisto, SCN2795KIvy James III · Seligman, AZN2795LHarkness Paul E · Richmond Hill, GAN2795URichardson Robert S · Austin, TXN27960Zeafla Steven J · Murfreesboro, TNN2796DFrance Gregory G · Alta Loma, CAN2796LSmyth Michael L · Saint Charles, MON2796NWestra John Jacob Trustee · Santa Ynez, CAN27972Miller Rondo T · Coon Rapids, MNN2797DEberhart Wayne Willis · Amboy, MNN2797KWalton T Michael · Hudson Falls, NYN2798JCenter Of Gravity Flying Club LLC · Monterey, CA
Back to AD 94-05-05 R1