AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8879BKatsahnias George T · Denton, TXN8880Causey Dale L · Albuquerque, NMN88808Thompson Patrick M · Madera, CAN8880UJackson Todd · Spirit Lake, IDN8881Steadfast Ministries · Alton, TXN8881DOlder Dan · Bellingham, WAN8882Landiedel Thomas DBA · Spokane, WAN8882DBanta Joshua Darracott · Dallas, GAN8882GSchauer Tad J · Lake Park, MNN8882SHudson Willis · Hendersonville, NCN8883BMoe Jean A · Detroit Lakes, MNN8883GPalacios David J · Yucca Valley, CAN8884BBrunson Aviation LLC · Little Elm, TXN8884SMechin Jean-Michel S · Gardiner, NYN8885GGurley George R · Caledonia, MSN8886BNeil John L Sr · Port Huron, MIN8888URomano Michael A · Fresno, CAN8889BDelise Nicholas M · Manteno, ILN8889UJennings Chadwick B · Reno, NVN888HHanley Michael · Paw Paw, MIN888JSmith Aviation LLC · Springer, OKN888UFNewman Carlon K · Cypress, TXN889Grasso Kurt D · Bridgeton, NJN8890BA-G-E Corp · Fort Pierre, SDN8890SPower Gale W · Girdwood, AKN8891GShort James B · Crown Point, INN8891SDahlen James T · Chester, MTN8892GMcnamee Paul J · Roseville, MNN8892UPropbusters Flying Club Inc · Wintersville, OHN88936Fischer Dan J · Houston, TXN8893GTurner Timothy D · Bonneau, SCN8894SArmstrong Richard R · Port Crane, NYN8894UMeyer Larry F · Brush, CON8895DMeggers Roger D · Baker, MTN8895SSyverson Kylie E · Prescott, WIN8896BFoster Michael W · Ellington, MON8896SWombles Earnest · Knoxville, TNN8897GShore Gerry · Inez, TXN8897STutak Peter B · Indianapolis, INFirst renewal noticeN8897URobison Stephen K · Frederick, MDN8898BThompson Christopher L · Durango, CON8899BBradberry Mason P · Wichita Falls, TXN8899UYoon Kerry D · Franklin, TNN88AOgden Christopher S · Chewelah, WAN88CYAnderson Mark · Bates City, MON88GMField Drew H · Dallas, TXN88HSShields Edwin G · York, SCN88KLRybczynski Douglas R · Tehachapi, CAN88KNRegistration Pending · Santa Rosa, CARegistration pendingN88LFBailey James L · Lewisburg, TN
Back to AD 94-05-05 R1