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.
N22897Donn Rex · Washington, UTN228NYFerguson Colt W · Wolf Point, MTN228WVarona Pedro A · Lake Placid, FLN22900Swanton Jed M · Shawnee, KSN22902Easterling William R · Pikeville, NCN22903Walther Newell A · Wasilla, AKN2290DVan Roy Gary J · Seven Bays, WAN2290KHansen Christian F · Tucson, AZN22915Sprankle Gerard · Fairbanks, AKN22918Treadway Timothy G · Burton, TXN22919Brozzo Ralph · St Johns, FLN2291DKauffman Phillip L · Castleberry, ALN2291VMorton Roger J · Baldwinsville, NYN22920Jackson Kenneth R · Stephenville, TXN22921Sakry Robert J · Saint Joseph, MNN22924Hirkala Ronald R · Weirton, WVN22926Gossett Rita M · Granbury, TXN22927Hamilton Gregory J · Avon Lake, OHN2292VBurton Robert E Jr · Vancouver, WAN22934Sonex Aircraft LLC · Oshkosh, WIN22935Tift Aviation LLC · Tifton, GAN2294DPlunkett Carton C · Terry, MSN2294KRicks Rebecca G · Hot Springs, ARN2294VWudtke Andrew T · Palos Park, ILN22956Thyfault Raymond E · Mattawan, MIN2295JPloyhart Edwin J · Harwood, NDN2295KObrien A Scott · Camarillo, CAN2295NHickam Steven A · Pinetop, AZN22963Swift John S · Santa Barbara, CAN22970Kingdom Air Corps · Sutton, AKN22978Tre Aviation Corp · Queen Creek, AZN22980Salt City Aviation LLC · Hutchinson, KSN22988Runyon James R · Entiat, WAN2298DAgaliotis Paul E · San Martin, CAN2298JRoth Mark E · Stevensville, MTN2298NHall David K · Madisonville, TNN2298VArnett Freddy H Jr · Yulee, FLN22990Peterson Curtis L · Smith Center, KSN22991Dan Munson Consulting Pllc · Seneca, SCN22998N22998 LLC · Middletown, DEN2299JMclaughlin Edward T · Silverdale, WAN2299KRusinowski Steve · Royal Oak, MIN2299NWard Worth W · El Cajon, CAN2299VDouglas-Carter Tammi A · Greenville, KYN22BQKahrhoff John R · Wentzville, MON22BTCrawford Michael R · Gainesville, GAN22BZ8k Investments LLC Series Cessna 150 · Perryton, TXN22DFBenjamin David E · Gardnerville, NVN22EFJordan Scott A · East Falmouth, MAN22GKKearns Joseph · Waverly, OH
Back to AD 94-05-05 R1