AD 2016-05-13
Registered aircraft · 3,126
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:2016-05-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
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:2016-05-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13') 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.
N847FEFederal Express Corporation · Memphis, TNN848FEFederal Express Corporation · Memphis, TNN848HAAerial Applicators Of Missouri LLC · Qulin, MON84BDWhite Birch Transportation · Lee, NHN84FCWilliams Fertilizer Services LLC · Oregon, MON84HSGc N84hs LLC · Layton, UTN85022Bergo LLC · Harrisburg, ARN8502ATumbleweed Leasing LLC · Tacoma, WAN8502HPope James D · Lewiston, IDN8504RRussell Armstrong And Danny Hawk DBA · Yuba City, CAN8504TWakefield Aircraft LLC · Cooperstown, NDN8506PDownstown Airport Inc · Vineland, NJN8506VKubecka Daniel P · Edna, TXN8507KA & M Flying Service Inc · Carlise, ARN8507NTumbleweed Leasing LLC · Tacoma, WAN8507SVan Namen Jonathan · Benoit, MSN8509SAir Tractor Inc · Olney, TXN8509TCrop Jet Aviation LLC · Gooding, IDN850DTalfin Leasing LLC · Heflin, ALN850WRAg-Tech Aviation Inc · Leland, MSN8511QDaniels Aviation Inc · Inverness, MSN8516JG3 Flying LLC · Merigold, MSN8516KFlatland Aviation LLC · Indianola, MSN8519VAdams Aerial Solutions LLC · Decatur, ILN851BFF & M Flying Service LLC · Columbus, MSN851CHCkw Aviation LLC · Dalhart, TXN851DCKansas Farm & Ranch Inc · Seneca, KSN851EMLos Angeles Police Department · Los Angeles, CAN851FEFederal Express Corporation · Memphis, TNN851LASun Valley Dusting Co · San Benito, TXN8521PThomas Air Service Inc · Hastings, NEN8521QCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN8521VJones Flying Service · Biggs, CAN8521WA & M Flying Service Inc · Carlisle, ARN8521ZAir Care Leasing LLC · Lamar, CON8522SDodson International Parts Inc · Rantoul, KSN8522YAero Applications Inc · Burley, IDN85239Shelton Agri Services Inc · Hereford, TXN8523JA & M Flying Service Inc · Carlisle, ARN8523LTwin Cities Aviation Inc · Yuba City, CAN8524FWallin Michael L · Walnut Ridge, ARN8524HMitchell Andrew D Trustee · Winnie, TXN8524LTri Rotor Spray & Chemical · Ulysses, KSN8524QMid-Cal Ag Aviation Inc · Kerman, CAN8525FJlr Ag Aircraft LLC · Fowler, CON8525QMagnum Aviation LLC · Goff, KSN8526LJack Olham Oil Inc · Dumas, TXN852DK402wd Holdings LLC · Corpus Christi, TXN853ALMetro Aviation Inc · Shreveport, LAN853FEFederal Express Corporation · Memphis, TN
Back to AD 2016-05-13