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.
N661MAAramco Capital Company LLC · DhahranN661SAPrometheus Air LLC · Middletown, DEN661WAKapowsin Air Sports Ltd · Shelton, WAN662LMFreedom LLC · Pass Christian, MSN662MAAramco Capital Company LLC · DhahranN662TWAgwerx Aviation Inc · Leawood, KSN662VAValley Air Applicators Inc · Indianola, MSN663LAAurora Cooperative Elevator Co · Aurora, NEN663MAAramco Capital Company LLC · DhahranN665JKSprinklermatic Florida LLC · Davie, FLN665LAJensen Aviation LLC · Pingree, IDN665MCGrindstaff Aviation Company LLC · Crossville, TNN665UHartley Flying Service Inc · Stuttgart, ARN666JMBank Of Utah Owner Trustee · Salt Lake City, UTN667CBDevil Dusters Inc · Artesia, NMN667SFBank Of Utah Trustee · Salt Lake City, UTN668THBank Of Utah Trustee · Salt Lake City, UTN669BABlue Air Training Corp · Las Vegas, NVN669JWKapowsin Air Sports Ltd · Shelton, WAN66TGAeroconnection King Air LLC · Miami, FLN66WDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN670RBOver The Top Aviation Inc · Jonesboro, ARN670WHHelimax Aviation LLC · Howell, MIN671PCAir Methods LLC · Greenwood Village, CON672LAGarrett Flying Service Inc · Danbury, TXN672PBJohnson River LLC · Durant, OKN672SDSweet Darling Sales Inc · Aptos, CAN673PCGarden St Aviation LLC · Fort Myers, FLN674LAFerriday Flying Service Inc · Ferriday, LAN674MRAg Air Inc · Sikeston, MON676DKSovereign Skies LLC · Russell, KSN676PCWeeks Kermit A Trustee · Polk City, FLN676WTHat L Management Inc · Midland, TXN677PJmc Air LLC · Dillsburg, PAN678ABHeart Rhythm Center Of Mississippi LLC · Flowood, MSN67AGA & L Farm Services Inc · Helena, ARFirst renewal noticeN67BAFlorida State Guard · Tallahassee, FLN67BWHarvey Robert B Jr · Fort Worth, TXN67CQBeech Baron LLC · Wilmington, NCN67DWDodson International Parts Inc · Rantoul, KSN67KDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN681CAJet Air Inc · Galesburg, ILN682ACDesert Sand Aircraft Leasing Co Inc · Rosharon, TXN683KRPeterson Tony D · Humboldt, IAN683MG1976 King LLC · Scottsdale, AZN684LARegistered aircraftN684SAUnited States Department Of State · Melbourne, FLN686LAFord Flying Service Inc · Doerun, GAN687LA5g'S Aviation LLC · Trumann, ARN688MCFlight Management LLC · Kirkland, WA
Back to AD 2016-05-13