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.
N82265Pike Marsha L · Reno, NVN8226BPerez Emanuel A · Calistoga, CAN8226FPrahin Michael H · Novi, MIN8226TDrain Jerald R · Gainesville, FLN8227AJin Jin Aviation LLC · Anchorage, AKN8227BSegovia Nicholas A · Mooresville, NCN8227SKashani Asher Farzan · Reseda, CAN8227TFulenchek Raymond D · Sherman, TXN8227UGeiger Russell K · Hilliard, FLN8227XMitchell Randall Dean · New Hampton, IAN8228Cross John · Canton, OHN8228SMorristown Flying Service Inc · Talbott, TNN8229BPittman Rex A · Haskell, TXN8229LWuest Steven D · Ripon, WIN8229SShanaman Baratt S · Ann Arbor, MIN8229TGreen Bernard L · Greensburg, INN8229UBurmeister James · Roseville, CAN8229XReynolds Lawrence C Jr · Anderson, INN822ATCalehuff David A · Muncy, PAN822BRichter Paul J · Chelmsford, MAN822RMGrant Ocey Earl · Donald, ORN822WEWalker James E · East Jordan, MIN8230BGrieff Jorden A · Rome, GAN8230LBridle Bit Ranch Co · Gillette, WYN8230TJstream Lc · Sheridan, WYN82312Pfau Michael G · Princeton, MNN8231BRegistration Pending · Wilmington, DERegistration pendingN8231FNeuman Paul · Campbellsburg, KYN8231XGhaderi Homayoun · Oakland, CAN8232BCosman Christopher M · Buckeye, AZN8232FSouthern Arkansas University Tech · Camden, ARN8232TDavidson E Bryant Trustee · Owasso, OKN8233AWeiblen Glenn P · Castroville, TXN8233LKensinger Steve · North Pekin, ILN8234BCook Christopher L · Mt Juliet, TNN8234THughes James G · Smartsville, CAN8234URegistered aircraftN82355Jaderborg Eric E · Lonoke, ARN8235ULind Gerald Wayne · Oakley, IDN8236ASchoettmer Thomas C · Greensburg, INN8236LCiroli Kenneth E · Indiana, PAFirst renewal noticeN8236TRobson Aaron T · Fairview, PAN8237SArth Richard E · Newcomerstown, OHN8237TLamattino Brandon L · Hanford, CAN8237UNo Money For Plane LLC · Grand Rapids, MIN8238AMoore Terrance J · Tacoma, WAN8238UPowers Robert · Iowa City, IAN8239LSkys Edge Aviation LLC · Midland, TXN8239XHess Dan A · Hastings, NEN823FStout Philip L · Ephrata, WA
Back to AD 94-05-05 R1