AD 2002-19-10
Registered aircraft · 1,092
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:2002-19-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-10')
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:2002-19-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-10') 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.
N2061LRoth Aerial Spraying LLC · Milford, NEN2064JPadgett Ag Rotors LLC · Missoula, MTN2065SSteggs Aerial Spraying Inc · Alva, OKN2067EFarm Air Flying Service LLC · Sacramento, CAN20700Meyerkorth Aviation LLC · Rock Port, MON20718Cartillar Enterprises Inc · Wynne, ARN20726A&M Flying Service Inc · Carlisle, ARN2072DPadgett Ag Rotors LLC · Missoula, MTN207LALocker Fred · Muleshoe, TXN209LAWest Valley Aviation Inc · Five Points, CAN211CHRegistered aircraftN212DTThiel Aircare Inc · Chowchilla, CAN212FBAero Spray Inc DBA · Appleton, MNN213BHBighorn Flying Co LLC · Wood River, NEN214RLLassco LLC · Middletown, DEN216TATailwinds Air Inc · Morganza, LAN224CNRegistered aircraftN226FBLipan Creek Flying Service LLC · Eola, TXN228DTGibbs Aviation Inc · Fremont, OHN228RGA+ Aviation Services LLC · Garden City, KSN22FKFast Ag Air LLC · Watertown, SDN22WHAeronautical Technologies Inc · Clovis, NMN2394RPalmer Flying Service Inc · Manito, ILN23WTAeronautical Technologies Inc · Clovis, NMN240DLBlue Earth Flying Service LLC · Blue Earth, MNN240LATwin Cities Aviation Inc · Yuba City, CAN244LAWoodline Aviation LLC · Memphis, MON246LAChambers County · Anahuac, TXN247SEThiel Air Care Inc · Chowchilla, CAN257CAHorizon Air LLC · Lumpkin, GAN257MSNeal Aircraft Inc · Slaton, TXN258LACrop First Aviation Inc · Stanfield, AZN259LAC & L Holzwarth Inc · Virden, ILN2602MWoodley Aerial Leasing · Walnut, ILN260LAGibbs Aviation Inc · Fremont, OHN263LACmk Aerial Inc · Sutton, NEN265FBFarm Brothers Flyers A LLC · Gould, ARN268FBFarm Brothers Flyers A LLC · Gould, ARN271LAA+ Aviation Services LLC · Goodland, KSN272DAAero Spray Inc DBA · Appleton, MNN274ATBoardman Air Service LLC · Henderson, NEN274BMEvergreen Flying Service Inc · Dover, DEN276ATBoardman Air Service LLC · Henderson, NEN277ATBoardman Air Service LLC · Henderson, NEN278ATBoardman Air Service LLC · Henderson, NEN281DLThisius Flying Service Llp · Wells, MNN281LABoedeker Flying Service East LLC · Childress, TXN282LAProp Ag LLC · Montezuma, KSN288KWFarm Air Inc · Astoria, ILN291DLNorthstar Aero Spray Inc · Clara City, MN
Back to AD 2002-19-10