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.
N3500CWilder Levi J · Anchorage, AKN3500JCattaraugus Flying Club Inc · West Seneca, NYN3500KPonder Jon E · Knoxville, ILN3500LDragonfly Aviation LLC · Winder, GAN3500SVasylenko Volodymyr V · Portland, ORN3501COlson Alan D · Oak Run, CAN35020Spears Dennis R Jr · Modesto, CAN35025Bennett Jacob W · Carrollton, MSN3502CMurphy Christopher K · Prescott, AZN3502DCianchette Eric L · Falmouth, MEN3502VFountain Trevin W · Junction City, ORN35035Registration Pending · Oak Grove, MNRegistration pendingN3503JBusiness As Usual LLC · Spartanburg, SCN3503NN3503n LLC · Lagrange, GAN3503VMock Joseph R · Huntsville, TXN35042Cayce Dick L Jr · Longview, TXN35052Montei Nicholas · Caro, MIN3505CFry Ravi M · Darby, MTN3505LPilot Training Northwest LLC · Sandpoint, IDN35067Lassiter Brent · Newport, ARN3507JLorentzen David P · Montrose, CON3507SBengen Dietrick K · Pasco, WAN3507VBrock Aviation Flight School LLC · Douglasville, GAN3508SParris Jack L · Pleasant Hill, MON35094Jt Airshows · Slidell, TXN3509CRollman Thomas Jaeger Trustee · Eagle River, AKN3509LNortheastern Oregon Flying Club · La Grande, ORN3509VLaakso David · Gaston, ORN350CCYellow Bird Adventures LLC · Austin, TXN350DEBrown Eric J · Belle Plaine, MNN3510DSkywagon Aero LLC · Wilmington, DEN3510JThiel Arleta J · Independence, ORN3511CNoll Richard J · Lehighton, PAN3511JMott William R · Beach Lake, PAN3511SRichard Daniel J · Orrington, MEN35124Kauffman Peter L · Sterling, AKN3513VHaussler Stephen K · Arlington Heights, ILN3514CKown William B · Hamilton, ALN3514VPlane Fun Inc Tr Trustee · Snellville, GAN3515STm Aviation Services LLC · Riverside, CAN3516DBickford Timothy · Limington, MEN3516JMitchell Clarence E · Las Cruces, NMN3516SBenedict Greg · Mason City, IAN3516VCoulter Ryan C · Portland, ORN35171Huddleston Herbert H Jr · Greenville, MSN35173Newby Aviation LLC · Pingree Grove, ILN3517CAnderson Robert A · Dove Creek, CON3517DStrange Willam H · Lewiston, IDN3517FCebelak William G · Kent City, MIN3517KMoore Orville G · Hays, KS
Back to AD 94-05-05 R1