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.
N8084XSnyder Paul G · Lincoln, NEN80850Travland Lewis H · Alpine, TXN8085BHowell Rebecca Elizabeth · Elgin, TXN8085LDowns Warren · Dillingham, AKN8085SSchulz Michael L · Norfolk, NEN80861Mouton Charles J Jr · Gladewater, TXN80862Ulmer Bryce D · Locust Grove, GAN80867Diver Simon R · Georgetown, TXN80869Bailey Robert L · Shoreview, MNN8086ANievin Garrett P · Ashburn, VAN8086TRains David O · El Paso, TXN8086XPaumen Kurt J · Ramsey, MNN8087ARichards Vincent C · Deland, FLN8087FWarbington Michael L · Enid, OKN8087LBawden Scott L · Saint George, UTN8087SBridges Jeffrey · Allen, TXN80883Gann Edward L · Brighton, CON80888Jensen Luke L · Burlingame, CAN8088LMarciano Raymond P · Cleveland, OHN8088SRutherford Thom J · Birchwood, WIN8088XSky 66 Aero LLC · Talala, OKN80891Richbourg Keith D · Waco, TXN8089FFlying A Aviation LLC · Archer City, TXN8089SBleier Rachel · Grayslake, ILN8089TGonzaez Richard · Granbury, TXN808ESStaples Safari Ministries Outreach · Clayton, WAN808FFlannigan Robert B · Ashland, MSN808KSDucks Are Free LLC · Salina, KSN80901Mccann Michael · Springfield, ORN80902Javarey David J · Corning, NYN80905Hoover Charles F · Oakdale, MNN80910Edmonds Jonathan · Jonesboro, ARN80913Perla Guido F · Vashon, WAN8091AHonrud Joseph C · Cal Nev Ari, NVN8091LSzarek Carlee B · Los Osos, CAN80922Montpelier Gary L · Bushnell, FLN80923Registered aircraftN80924Legacy Flight Museum · Rexbury, IDN8092BHering Robert A · Anchorage, AKN8092VRohm Arne · Miller, MON80932Swift Museum Foundation Inc · Athens, TNN80933King Larry Joe · Quanah, TXN8093FHardy Peter Nicholas · Los Osos, CAN8093LNevins Mark B · Gresham, ORN8093TScholl Adam J · Garretson, SDN80947Butler Steve L · Sioux City, IAN80949Barker Bradley C · Houma, LAN8094BRutherford County Air Rescue Squad · Rutherfordton, NCN8094TMapes Rocky A · Thornton, CON8094XJenkins Matthew · Bend, OR
Back to AD 94-05-05 R1