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.
N823PWSpradley Jeff D · White Springs, FLN823WSMcinturf Paul A Jr · Childress, TXN823ZMarther Thomas L · Albion, PAN8240F14a Flying Club Inc · Mooresville, NCN8240LCactus To Clouds Aviation LLC · Indio, CAN8241BBalint Jozef · Fort Worth, TXN8241URegistration Pending · Casa Grande, AZRegistration pendingN8241XRotormate LLC · Royse City, TXN8242BLibby Robert E · Windham, MEN8242XSadique Said-Hesamadine · Fairfax, VAN82439Weigel John C · Natick, MAN8243XDemetreu Thomas J · Almond, NYN8244AMiles Robert A · Maupin, ORN82458Barr Bruce A · Lander, WYN8245AAdriatic Holdings LLC · Cheyenne, WYN8245FMorisette Michael W · Antelope, CAN8246BBoyer Christopher · Bozeman, MTN8246FTalikka Todd · Paulding, OHN8246LPatak Eva L · Ennis, TXN8247BDoughty Robert W · Casa Grande, AZN8247FCarson Leonard H · Chesapeake, VAN8247LKnepp Terry · Montgomery, INN8247UComeau Paul D · Walden, NYN82485Strom Kerry · Portal, NDN8248AEllis John D · Hodgenville, KYN8248FLucia Steven R Sr · Agawam, MAN8248LBattleshaw Raymond · Weidman, MIN8248URobison Wm Lee · Smithville, MON8249TTolmachev Nikolay A · Anchorage, AKN8249UDracka Charles L · Port Clinton, OHN8249XDish Technologies LLC · Elm City, NCN824RJScaber Daniel · Ormond Beach, FLN8250ARyan Craig M · Corona Del Mar, CAN8250BMortenson Daniel R Trustee · Newhall, CAN8250FRyan Good Aviation LLC · Sioux Falls, SDN8250LStieler David C · Marlette, MIN8250SRegistration Pending · Statesville, NCRegistration pendingN8250UCalderon Daniel · Orlando, FLN8250XVolk Kenneth Lee · Marshall, TXN82515Pangelinan Regina Mafnas · Dublin, CAN8251AJulius William C · Julesburg, CON8251TSkylark 61 LLC · Fair Oaks, CAN8251XInman Charles E · Havre, MTN825225 Pm Inc · Nampa, IDN8252ADuane Peters · Anchorage, AKN8252LSky And Summit Aviation LLC · Suwanee, GAN8253FSinclair Jerry D · Watonga, OKN8253LKostroski Larry J · Tucson, AZN8253THolzgrove Daniel R · Detroit Lakes, MNN8253XMasters Mission · Robbinsville, NC
Back to AD 94-05-05 R1