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.
N27999Bradshaw William D · Mc Bee, SCN2799CTaylor James L · Lowell, ARN2799NJon D Robb · Alma, MIN2799UWinslow Linda S Trustee · Creswell, ORN279MCMagic Carpet LLC · Wilmington, DEN27CSFeauto Aviation Inc · Saint Cloud, FLN27DFDavis Nolan E · Juneau, AKN27DTThomas Dennis K Trustee · Little Rock, ARN27EDSpruce Creek Flyboys LLC · Port Orange, FLN27GMJimenez Raymond C · Gardena, CAN27HTims Duane R · Hemet, CAN27JMAlldredge Aviation · Auburn, WAN27QHanson John W · Stewartville, MNN27TDMenor Michael D · Menominee, MIN27XBWalters Jonathan H · Malvern, OHN2800CLinares Francisco E · Miami, FLN2800HGriggs Geri L · Kingsville, OHFirst renewal noticeN2800LGarcia Fernando · Laredo, TXN2800SSimpson Gavin J · Medford, ORN2800UFAA LLC · Big Lake, AKN2801CMurphy Ronald D · San Jose, CAN2801NK & K Aircraft LLC · Culver, ORN2801SLavere Paul · Adams, NYN2801UDallas Flying Associates Inc · Dallas, TXN28023Island Airways LLC · Marion, WIN2802CHarris Timothy T · Belvidere, ILN2802NAllen William T · Hawarden, IAN2802SBurt Charley R · Anchorage, AKN2802UPatterson Bud N · Perry, OKN2803CGrant Alison J · Rocklin, CAN2803USwan Aviation Ministries Inc · Laurel Hill, FLN2804EHingtgen Ricky L · Rincon, GAN2804SAlmy David W · Riverside, CAN2805Somes Jason S · Santa Rosa Valley, CAN2805CYakubisin Jeffrey · Beach City, OHN2805UContinental Skylarks Inc · Deer Park, NYN2806UWeeber Charles · Pelham, MAN2807LBerisha James · Porter, TXN2807UMeese Brian D · Conroe, TXN28084Clark Christopher W · Fallon, NVN2808HBellomy Andrew · Hasty, CON2809LWarner Walter M Jr · Willow, AKN2809NKalabus Edward A Jr · Dallas, TXN2809UBleskan Erick J · New Berlin, WIN280VFKaczmarek Richard G · Sandersville, GAN28104Aubin Carol M · Bangs, TXN2810SWaco West Inc · Dover, DEN2810UN2810u LLC · Delray Beach, FLN2810VDipasquale Glenn D · Gloversville, NYN28113Butler William M · Wichita, KS
Back to AD 94-05-05 R1