AD 94-05-05 R1
Registered aircraft · 26,232
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.
N77239Corr Zachary R · Santa Paula, CAN7723FSchlueter Rodney E · Kansas City, MON7723UAdams David C · Westford, MAN77244Debons Jeremy A · Lexington Park, MDN77245Fcboulder LLC · Boulder, CON77248Stolley Nicholas A · Webster, MNN77249Snead Travis S · South Boston, VAN7724XJohnson Randy G · Collinsville, OKN77253Raasch Keith A · Gresham, WIN77254Pace T Kem · Ridgeway, VAN77257Mix Timothy R · Hubbard, ORN7725FToney Michael · Saint Peters, MON7725UCvz-Vivace LLC · Fort Worth, TXN77265Registered aircraftN77266Gates Eric C · Menomonie, WIN7726FWargacki Darrin W · Hamilton, OHN7726XTop Profile Management LLC · Somis, CAN77275Rodriguez Joseph Ray · Lake Elsinore, CAN7727UWingtip Aviation LLC · Amarillo, TXN77281Hiemstra Thomas R · Sonora, CAN77282Gallman Alexander C · Livingston, TXN77284Hernandez Jorge L · Luthersville, GAN7728UKropp Richard G · North Creek, NYN77291Borden David M · Los Angeles, CAN77297Cullman Daniel H · Kent, WAN77298Shooting Star Services LLC · Rosamond, CAN7729EMaldonado Abel N · Santa Maria, CAN7729FCardenas Enrique · Brownsville, TXN7729UBlough Lynn M · Pittsburgh, PAN77304Deckard Steven · Wellington, NVN7730FBmg Aviation Leasing LLC · Bloomington, INN7730GSellet Jack A · Winter Haven, FLN77310Picquet Blake · Albany, TXN77312Van Lehn Sethany A · Frederick, MDN77315Kostroski Larry J · Tucson, AZN7731FN7731f LLC · Portage, MIN7731TNash Leslie W · Bentonia, MSN7731UMd Aviation Inc · Sioux Falls, SDN77325Ellis Sean J · Eagle River, AKN77328Juenke David Parker · Fort Bragg, CAN7732XLinstad Daniel E · Canby, ORN7732ZDriskill Larry W · Lubbock, TXN7733Norris Joseph B · Oshkosh, WIN77330Steiner Zachary J · Bethlehem, CTN77333Mortenson Dennis L · Spanaway, WAN77334Rotert Adam · Tulsa, OKFirst renewal noticeN77335Zambelli Robert G · Manning, SCN7733TSiu Ena · Reno, NVN7733UGutlon Richard S · Durham, NCN77341Monti Marco G · Mechanicsville, VA
Back to AD 94-05-05 R1