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.
N2211KWittstock Duane C · Norwalk, IAN22123Hughes James H · Northlake, TXN22128Sale Reported · Royal, ARSale reported, pending cancellationN22129Morrison Dwayne L · Columbia, SCN2212BAnderson Mark A · Bates City, MON2212EFletcher Stephen J · Labelle, FLN2212NScott Brian Trani · Parachute, CON2212VLewis Gavin · Schererville, INN22130Kall Joseph F · Bozeman, MTN22135Rosales Ruano Irving A · Plantation, FLN22138Obert Robert V · Dunnellon, FLN2213HValentine Rolland N · Atlanta, MIN2213JKlemp Darrel D · Bonduel, WIN2213VHackens Donald G · New Underwood, SDN22142Cummings Ezekiel · San Antonio, TXN22145Mcdowell Jhonathon P · Lake Alfred, FLN22146Star Voyages LLC · Kissimmee, FLN22147Morris Gregory A · Arlington, TXFirst renewal noticeN2214BWilhite John R · Red Oak, TXN22150Cody Edward H · Benton City, WAN22151Soren Sky LLC · Riverside, CAN22153Carter Gary J · Manlius, NYN22155Anady Aviation LLC · Hemet, CAN22157Potter Colin J · Piedmont, SDN22158Million John B · Westminster, MDN22159Registration Pending · Phoenix, AZRegistration pending, canceledN2215JRogers Gary A · Novi, MIN2215NAnsorge Inc · Elk Grove, CAN22160Evert Linda L · Golden Valley, MNN22162Red Oak Commuter LLC · Red Oak, IAN2216BGrass Brian S · Ocala, FLN2216NVillegas Joshua A · Bradley, CAN2216VApisson John G III · Riviera Beach, FLN22170Taylor Warren D · Las Vegas, NVN22172Soerens Thomas D · Saint Charles, ILN2217HGassert Kevin J · Cincinnati, OHN22183Allworth Burton · Wapello, IAN22190Mulhall Kathy · Fishtail, MTN22191Perry Oien · Deadwood, SDN22192Pecinovsky Clair · Cresco, IAN22194Schmidt James P · Omaha, NEN22196Showah Michael F · Scottsdale, AZN22197Frallicciardi Vincent Jtrust · Madawaska, MEN2219BPuls Kurt V · Valparaiso, INN2219DRogers David R · Lake Jackson, TXN2219JMcnamara Bradley W · Seattle, WAN2219NFalkenhagen Lonnie D · Menifee, CAN2219VMeisdalen Glenn C · Malta, MTN221AGryczewski John · Olive Branch, MSN221BKThielen Andrew J · Atlantic, IA
Back to AD 94-05-05 R1