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.
N7959TArrow LLC · Pateros, WAN7959UShugart Tiffany C · Canfield, OHN795PSPas Services LLC · Townsend, DEN7960BHolte Martin W · Burnsville, MNN7960THayden James R · West Fargo, NDN7961BGmitter Joseph J · Forest Lake, MNN7961TBoardman Thomas M · Greenwich, NYN7961XCarruth Sam · Ripon, CAN7961ZBoho LLC · Lewes, DEN7962BHall Jason J · Moses Lake, WAN7962ENesta Alex · Winder, GAN7962FFlying Colors Airparts Inc · Leesburg, FLN7963BPerkins C Trent Blaise · Wonder Lake, ILN7963TSawyers Susan J · Tazewell, VAN7963UKischnick Brett A · Lapeer, MIN7963XHairetown LLC · Johnson City, TNN7964XEdwards Jerry T · Palo Pinto, TXN7965ELangton Kathy A · Exeter, CAN7965ZElliott Frank F · Mojave, CAN7966BBrashar Kevin · Anchorage, AKN7966UPatterson Robert E Trustee · Petaluma, CAN7967BScholz Alan A · Rosamond, CAN7967TMachowicz Mark M · Eastpointe, MIN7967XSchneider David L · Saginaw, MIN7967ZBreckenridge Steven C · Farmington, ILN7968BWaltz Patrick T · Delanson, NYN7968FFlyin Cowboys · Manning, NDN7968TSiegel Donald S · Northampton, MAN7969BConnolly Patrick J · Skaneateles, NYN7969XBurnham Bros · Winner, SDN796WTTaildragger LLC · Blackfoot, IDN797Hoctor Ray B Jr · Webster, TXN7970EMckenna Terence M · Scotts Valley, CAN7970FConnor Christopher Donnie · Chicago, ILN7970UChard Robert L · Byron Center, MIN7971BKimberling David L · Lincoln City, ORN7971UHallstrom Curtis R · Barnesville, OHN7972ZResley James B · Sierra Blanca, TXN79731Nicolle Noel T · Gurley, ALN7973EDunham Matthew J · Duarte, CAN7973ULewis Mark A · Ozark, ALN7974BBraymer Jay K · Boerne, TXN7974EJstream Lc · Sheridan, WYN7974FMerriam Hugh M · San Leandro, CAN7974TByers Theresa L · Freedom, CAN7974XKalamazoo Flight Instruction LLC · Kalamazoo, MIN7975UStrickland Paul A · Goleta, CAN7975XGessinger Gregory S · Nappanee, INN7975ZLansing Community College · Mason, MIN7977UWittenburg Brandon L · Vancouver, WA
Back to AD 94-05-05 R1