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.
N50171Evans Mark E · Heber Springs, ARN50177Dudley Lee B · Passadumkeag, MEN5017AMeixell David Matthew · Santa Maria, CAN50180Robbins Richard T · Ketchikan, AKN50181Debelius Enemark Peter C · Crawfordville, FLN50184Wietecha Jack · Millington, ILN50188Ryburn Michael D · Basehor, KSN5018ABadger Daniel J · Yellow Springs, OHN50194Brouillette Jakob D · Daleville, ALN501PAChapman Anthony J · Henderson, NVN501WAFerrari Jason M · Medina, OHN50201Ahrens Brian T · Hainesport, NJN50202Velasquez Jorge · Brawley, CAN50205Spruce Moose LLC · Salt Lake City, UTN50209N Maple LLC · Kalispell, MTN5020GBaum Karl Bradley · Brookings, ORN50213Canarr Randall J · Anchorage, AKN50219Sftb LLC · Miami, FLN50221Smith Wayne A · Uxbridge, MAN50222Baldwin Kevin R · San Tan Valley, AZN50224Reshetar Ryan D · Evansville, INN5022HChapman Doug S · Belgrade, MTN50231Aaronflight LLC · Hillsboro, ORN50232Firby John E · Diamond, OHN50234Lloyd Barry C · Sacramento, CAN5023NDoolin Danny J · Bowling Green, KYN50245Christian Martha J · Ham Lake, MNN5024ADucharme Matthew B · Harlem, GAN50251Featherston Nicholas L · Chandler, AZN50252Price Benjamin A · Hattiesburg, MSN50255Andrews Michael E · Huron, OHN5025HWatson Jeffrey D · Anchorage, AKN50261Copeland Joey A · Douglas, GAN50262Garrison Vincent Gray · Yadkinville, NCN50263Registered aircraftN50266Plentl Steve R · Shepherd, TXN50267Buckner Natasha · Locust Grove, VAN50268Mach Steven William · Chicago, ILN50269Joerger Dannie L · Greensburg, INN50270Flanagan Elizabeth M · Coronado, CAN50274Currie William O · Lumberton, NCN50276Pense Richard L · Katy, TXN50283Sanchez Oscar A Blanco · Portsmouth, VAN50284Dunaire LLC · Mechanicsburg, PAN50286Baue Michael G · Foristell, MON5028AVonszilassy Peter · Fredericksburg, VAN50292Wheeler Richard Edmond III · Norfolk, VAN50297Eddleston Ryan · Winter Haven, FLN50299Wood Thomas J · Overland Park, KSN502ACSwicord Steven E · Florala, AL
Back to AD 94-05-05 R1