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.
N77013White Stephen M · Brunswick, MEN77016Zucchero David M Jr · Stanwood, WAN77017Registration Pending · Kalamazoo, MIRegistration pendingN77018Madden Robert W Jr · Nome, AKN7701UIyer Sundaresh R · Northborough, MAN77028Smith Jimmy A Jr · Albemarle, NCN7702EWhite Don DBA · Mount Vernon, WAN7702TNablo Dustin · Haddam Neck, CTN77032Registered aircraftN77041Registered aircraftN77048Chapman Gary · Milton, WVN77049J R Bane Land Corporation · Oakland, IAN7704UAllen Philip · Portland, ORN7704XStark Linda L · Arroyo Grande, CAN77050Cache R Bridges · Girdwood, AKN77051Allen Benjamin L · Millen, GAN77053Linden Richard M Jr · Dallas, TXN7705EGerber James R · Larchwood, IAN7705FEisel Joseph D · Dexter, ORN7705UCaldwell Evan-James Gray · Camano Island, WAN77061Magallanes Luis Alberto · Miami, FLN77062Monahan Steve G · Billings, MTN77063Daniels Robert Douglas · Greenville, TXN7706XAircaft Guaranty Corp Trustee · Oklahoma City, OKN7707TAmerican Petro Inc · Ball Ground, GAN7707UMeese Brian D · Conroe, TXN77082Arps Alan D · Schuyler, NEN77083Beigle Harvey T · Prescott, AZN77086De Velde Nathaniel C · Dallas, TXN7708UDahle Jacob J · Morristown, MNN77093Schmitt Mark R · Rockford, MIN7709FChiang Yucheng · Glenview, ILN770LCJet Air Inc · Iowa City, IAN770LLBrant Merle G · Potomac, ILN770NAOrganization Of Black Aerospace Professionals Inc · Westchester, ILN770SPHa Emily J · Fort Worth, TXN77102Newton Christopher F · Avon, INN7710TMorton David W · Brady, TXN7710XGraves Robert D · Elberton, GAN77114Bowers Byron L · Lafayette, CAN77116Wetherby Anna Rebecca · Wendell, MAN7711EHeaton Stewart · Spanish Fork, UTN7711FMcclain Eugene L · Maryville, TNN7711TBaker Eddy · Waynesville, ILN7711UHaneline Douglas A II · Statesville, NCFirst renewal noticeN77121Bays Joseph K · Weirsdale, FLN77123Cardillo Jeffrey Douglas · Bridgeton, NJN7712UGolding James M · Diamond Springs, CAN77130Gilbert Scott A · Cedar Rapids, IAN77132Stamsta Marc J · Hartland, WI
Back to AD 94-05-05 R1