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.
N82950Fletcher Flying Service 419 LLC · Labelle, FLN8295AHairston Marvin A · Peck, IDN8295BSkywriters Inc · Ferndale, WAN8295UCrawfish Co LLC · Starkville, MSN8297BSchler Joseph B · Reno, NVN8297SBergmann Joshua A · Menomonie, WIN8297UMcburney Richard O · Hudson, NCN8298FAustin Leslie M · Greenville, INN8298UCollins Roberto · Naples, FLN82992Carman Glenda M · New Freedom, PAN82994Schmidt Robert A · De Forest, WIN8299AStevenson James W · Oregon, WIN8299BJohnston Keith G · Honolulu, HIN8299SMcauliffe John P · Livonia, MIN8299XBeail Herschel D · Quincy, CAN82ACSoutheast Lsa LLC · Jacksonville, FLN82DLMcdonald Ernest M Jr · Valdosta, GAFirst renewal noticeN82EDRodriguez Rolando · Harlingen, TXN82GJJohnson Glenn I · Berry Creek, CAN82GRRoberts Calvin D · Bluebell, UTN82LRuppert Russell E · Dover, PAN82REEpton Richard C · Williamson, GAN82USmedley Randal C · Seadrift, TXN8300AChapa Jana K · Corpus Christi, TXN8300BMonger Kenneth R · Bella Vista, ARN8300UFrisby Richard V · Fredericksburg, VAN8301AFrazer Wendy J · Meridian, IDN8301UN8301u LLC · White Springs, FLN8301XLindeman Rusty · D Hanis, TXN83023Hopkins James D · Wasilla, AKN8302GLittle Air Dream LLC · Mooresville, NCN8302XManley Stephen Edward · Carrabelle, FLN8303AMiller A Barry · Lincoln, ILN8303BBack Jason M · Poolville, TXN8303JFodero Jesse G · West Seneca, NYN8303TBingham John V · King George, VAN8304BWarzecha Kathy A · Sauk Rapids, MNN8304HKimball Ed R · Woodland, CAN8304XAeschliman Arlie W · Tribune, KSN83050Paglierani Gary B · Fresno, CAN83056Segura Richard J III · Henderson, TXN8305BHansen Mark A · Savannah, GAN8305MGossage Terrence L · Port Angeles, WAN8305TBradford Alfred G · San Antonio, TXN8305USkyhawk Leasing LLC · Port Huron, MIN83066Dierker James L · Tulsa, OKN8306BCoopsair LLC · Saint Petersburg, FLN8306GLees Michael S · Port Allen, LAN8306TBowers Roy L · Valley Springs, CAN8307ASweetnam G Leslie · Woodstock, CT
Back to AD 94-05-05 R1