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.
N80953Benson Wayne L · Wurtsboro, NYN80955Lane Kevin M · Fort Wayne, INN8095BYeagley Daun E III · Moraine, OHN8095TCarter Audie L · Port Saint Lucie, FLFirst renewal noticeN8095XBall Christopher B · Homer, AKN80963Koester John K · Cottage Grove, ORN80966Holliday Mark · Lake Elmo, MNN80969Windsock Capital LLC · Bertram, TXN8096TSchoonover Emma L · Wichita Falls, TXN80971Simmons Aeronautical LLC · Springfield, MON80973Williams Daniel L · Pickrell, NEN80974Richbourg Keith D · Waco, TXN80977Van Pelt Martin J · Venice, FLN80978Smith David Carroll · Brewster, WAN8097LPeters Aero Plus LLC · Freeland, MIN8097XKublank Nathan S · Sun Prairie, WIN80983Walz Thomas D · Lakeville, MNN80986Albright John W · Richmond, INN80989Aviation Trust Company LLC Trustee · Oklahoma City, OKN8098AGann Clifton T · Guthrie, OKN8098LJordan James R Trustee · Hermon, MEN8098XRaphael Christopher M · Colorado Springs, CON80993Kerby Brett · Orem, UTN80995Theen David R · Englewood, FLN80997Jenkins Johnny L · Dallas, GAN80999Troeleman Nicholas D · Sun City Center, FLN8099BKlosterman Aviation LLC · Celina, OHN8099LMateaki Koreen · Anchorage, AKN809BSecker Timothy A · Olympia, WAN809BPPhillips Robert Geise · Lake Charles, LAN80CAThomson Ian W · Anchorage, AKN80CWEngel Chadd D · Danville, INN80DTTerasaka Kotaro · Moab, UTN80HHoward Roland Dean · San Antonio, TXN80JKBaginski John P · Winchester, CAN80KBRutan Aircraft Flying Experience · Waller, TXN80PPN80pp LLC · Titusville, FLN80RGBorg Michael A · Aptos, CAN80SHValencic Adam · Apopka, FLN80VEStapleford Paul R · Laveen, AZN8100SHigh Exposure Inc · Wilmington, DEN8101LDickson Aaron M · Arkadelphia, ARN8101UWeirick Kelly M · Morganton, NCN8101XBreuer Elizabeth · Horseshoe Bend, IDN8102ABuck Randall J · Greenfield, INFirst renewal noticeN8102DReilly Herbert V · Bloomingburg, NYN8102FFerrier Robert Clifford · Lindsay, CAN81030Russell Michael G · Condon, MTN81033Kreikemeier Spencer · Manhattan, MTN8103ACronk Kenneth B · Woodrow, CO
Back to AD 94-05-05 R1