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.
N73014Hunter Nicholas · Irwin, PAN73016Devault Chelsey · Katy, TXN7301MLeaders Bob O · Clear Lake, MNN7301THolte Martin W · Burnsville, MNN73021Wall David K · Ocala, FLN73022Edwards Christopher V · Seattle, WAN73023J & T Aviation Llf Inc · Sparks, NVN73026Plane Fun Inc Tr Trustee · Snellville, GAN73029Riley Gary L · Prescott Valley, AZN7302ASkywagon Aero LLC · Wilmington, DEN7302MKoenig Donald J · Las Animas, CON7302TSchaff James F · Prescott, AZN7302XGlover Thomas · Marana, AZN73034Mueller Gary L · Eagle River, WIN73037Borris Roy E · Miltona, MNN73039Schmidt David S · Brooksville, MSN7303ALogajan James M · Rapid City, SDN7303GGolden Greg J · Thurman, IAN7303MHerbert Robert Leo · Ammon, IDN7303XBosch Kent D · Montevideo, MNN73045Strachan Darrel A · San Jose, CAN73046Sutton Aircraft Salvage LLC · Palmer, AKN7305AK&M Aviation LLC · West Liberty, KYN73065Austin Donald B · Locust Grove, GAN73066Registered aircraftN7306AFloyd Ckyler Don · Bowman, NDN7306TFaull Ron W · Sandpoint, IDN73077Egmond Aircraft LLC · Lewes, DEN7307ACook Raymond L · Clarksville, TNN73081Sale Reported · Lone Jack, MOSale reportedN73086Mayo William J Jr · Reed Point, MTN73087Plane Affair LLC · Miami, FLN7308TBerg Weston L · Stanton, NDN7308XEsmond Emmett W · Seattle, WAN73092Lynch Susan S · Saint Inigoes, MDN73094Denouden Ronn · Rochester, MNN73096Hammerle Tye F · Kenosha, WIN73099Lawson Lonnie B II · Linden, PAN7309MDunn Louis Jr · Mooresville, NCN7309TRognlie Brent R · Westminster, CON7310TYowell Albert W · Etlan, VAN7312AJohnson Thomas F · Buckeye, AZN7312GKlitzke Lucanus E · La Plata, NMN7312THangar 20 Flying Club LLC · Climax, MIN7313APerkins David A · Locust Grove, OKN7313GBend-Over Hill Aviation LLC · Dover, DEN7314ASchultz David · Middleton, IDN7314MFrickel Daniel R · Atkinson, NEN7314TCarney Mark A · Emporia, KSN7315ATiny Sparrow Aviation LLC · Irvine, CA
Back to AD 94-05-05 R1