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.
N5962EWagar Dennis Murphy · Marion, MTN5962GVaught Andrew W · Long Beach, CAN5962RN5962r LLC · Auxvasse, MON5962VDowns Steve M · Camden, TNN5963GInternational Air Services Inc Trustee · Carson City, NVN5964ABeachy Matthew · Russellville, KYN5964TColburn Shawn M · Monroe, GAN5965CSmall Clinton M · Sloan, IAN5965GCavu Pilot LLC · Powell, TNN5965TJones Robert · Gulf Breeze, FLN5966AHutchins Charles Norman · Wildomar, CAN5966EHowe Allen R · Waterloo, WIN5967ERegistration Pending · Winter Haven, FLRegistration pendingN5968JAragon Cecilia R · Sequim, WAN5969EFithian Michel · Putnam Valley, NYN5969RFrederick Clint A · Mattoon, ILN5970EKolodziejczak Benjamin D · Orchard Park, NYN5970GOritz Benjamin Dale · Senoia, GAN5970TOmlid Robert L · Watford City, NDN5971ABolton Warren S Jr · Niles, MIN5971RBowers Joshua Shane · Ballston Lake, NYN5972AWillams Christopher R · Lingleville, TXN5972ESutton Aircraft Salvage LLC · Palmer, AKN5973EKcantarano LLC · Mukilteo, WAN5974EHunt Ellwood M · Texarkana, TXN5975ADuke Robert D · Darrouzett, TXN5975EFoley Charles E · Poland, MEN5975RBates Kristopher M · Zanesville, OHN5976AN5976a LLC · Marathon, FLN5976RMeadows Robert K · Macon, GAN5976TBickel Garret E · Perry, MON5977JTemplet Eugene P · Pearl River, LAN5977RWhitney Nathan B · Falkville, ALN5977TBass Daniel J · Winona, MNN5978JVigil Clyde R · Chimayo, NMN5979ELamarca Kenneth M · Jonesboro, GAN5979GHargrave Michael K · Gladwin, MIN5980AFinstad Brandon C · South Weber, UTN5980GBall Albert N · Chugiak, AKN5980RPetes LLC · Pompton Plains, NJN5981ENelson David F · Onalaska, WAN5981RKenney Anthony G · Oviedo, FLN5981TLowe David · Sacramento, KYN5982EAblaihan Inc · Angels Camp, CAN5982TLifto Thomas W · Barronett, WIN5984GClifton Raymond L · Pleasanton, TXN5985ARimes Aviation LLC · Worthngtn Spg, FLN5985EAlderman Melvin R · Jacksonville, FLN5985GStanton Aviation Lc · Saint George, UTN5987ALong Randy M · Dewy Rose, GA
Back to AD 94-05-05 R1